Conditional back color of box.

[BatmanMR287]

I have a report that shows the answers to multiple choice questions from a survey. The answers in the database are 3,2,1. In the report I need to have the back shading color reflect the numeric answer. Green for 3, yellow for 2, and red for 1.
I know it will be a nested If statement but not sure how to write it.

[Bob Fitz]

Have you tried doing this without code and just using Conditional Formatting on the ribbon.

[BatmanMR287]

That does work well, unfortunately I have to do it 42 times. Don't see a way to copy and paste.

[BatmanMR287]

Ah Ha! They are sub reports so I can copy them and change the query. Great solution and looks good. Thank you Mr. Fitz.