conditional formating if and And

[ROPL]

Hi help please,

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

I am trying to write if field F3 quotes "Schedule booked" And the amount
(field d3) is less than (field c3) change the colour to (what ever I choose).

My formular is not working! I am no expert as you can see.

 

[Stefi]

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

„ROPL†ezt írta:

 

[Jacob Skaria]

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

If this post helps click Yes