View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default conditional formatting if ANd

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



On 24 Kwi, 12:11, ROPL wrote:
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.
--
--
K