Hello,

If we click on a cell (Mine is Z9) and then you click on "conditional formatting" and then on "manage rules", we come to a "conditional formatting rules manager" window!

I would like Z9 to be conditionally formatted based on two dropdown cells located at M9 and N9, When M9 shows " ***", and N9 shows anything other than " ***", I would like the
Z9 cell to show red. Anything other than this condition, I want Z9 to show white.

Heres the two rules I put in:

=AND(N9=" ***", N9=" ***")
>>> show white


and

=AND(M9=" ***", N9<>" ***")
>>> show red

Somehow this is not working for me.

Can anyone help me!

Thanks in advance!