conditional formatting if and And

[ROPL]

Hi,

=OR(F3="Schedule booked",AND("D3<C3"))

I am trying to write if cell F3 reads "Schedule booked" AND cell D3 is less
than cell C3 then statement is true so field should change colour.

Help, my formular is not working.

 

[Jacob Skaria]

Check your other post..You dont need to duplicate..

OR is not needed. Use the AND(condition1,condition2)
Done use double quotes for references....

=AND(F3="Schedule booked", D3<C3)

 

[ROPL]

I had to duplicate as the system informed me it has not been sent.

Your answer is perfect. Thank you so much.