Formatting a textbox (color) based on value

[Mgomp]

Hi all.

I have a report, and one of the fields are showing a Yes or No value.
I am trying to let the texbox's background color changing from eg. light red with the value No and light green with a value Yes in the field.

Is this possible, if so - how can I fix this?

Regards.

 

[pbaldy]

Check out Format/Conditional Formatting (on the ribbon starting in 2007).

 

[Mgomp]

Thanks!!

I haven't seen this. It works absolute perfect!

Regards

 

[pbaldy]

Happy to help. Conditional Formatting is definitely a good tool to have in the bag.