conditional formatting if ANd

  • Thread starter Thread starter ROPL
  • Start date Start date
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.
 
Back
Top