Hi

I have a database of circa 100 audit questions and for each answer is a combo box for Yes: meets the standard, No: Minor NC, No: Major NC, OFI and N/A.  I would like to be able to format the fill colour of a text box below each question based on the value of the combo box field (traffic light system) with grey for null or “N/A” and wondered of there is a simple solution for this.  So far, I can only find conditional formatting as a solution but this requires 5 different formats for each individual question.

I’d very much appreciate being pointed in the right direction.

Thanks.

​Hi I have a database of circa 100 audit questions and for each answer is a combo box for Yes: meets the standard, No: Minor NC, No: Major NC, OFI and N/A.  I would like to be able to format the fill colour of a text box below each question based on the value of the combo box field (traffic light system) with grey for null or “N/A” and wondered of there is a simple solution for this.  So far, I can only find conditional formatting as a solution but this requires 5 different formats for each individual question. I’d very much appreciate being pointed in the right direction. Thanks.  Read More

​