Changing row color based on changing values.

[Elijah Lewis]

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]

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.

[#3]

Thanks so much.  I knew I was missing something easy.  Totally working great now, thanks again!