conditional formatting if ANd

R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting if and And 2
conditional formating if and And 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
IF greater than...IF less than....====== 3
Time sheet template military hours problem 6
Formula so that response is >value 4
Conditional formatting with time 4
multiple cells conditional formatting 3

Top