Hello,

I need help with conditional formatting. I need to be able to change the color of a cell based on information in another cell. For example if A1 = Yes A2 is red, If A1 = No A2 is green.

How can I do this?

Thanks!