Forum Discussion
Changing row color based on changing values.
My first column has a pull down menu in which the 3 choices are Y, N, and O. If user selects N or O then I want the color to change to light red and light blue respectively with no color on the Y choice. Everything I try just the first column changes color and I need the whole row to change color.
2 Replies
Hi Elijah,
Use formula for conditional formatting rules. You need two of them, for each color. Formula is like
=$A1="N"
and apply the rules to your entire rows or range you'd like to color
Please see attached.
Thanks so much. I knew I was missing something easy. Totally working great now, thanks again!
