View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default conditional formating if and And

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

If this post helps click Yes
---------------
Jacob Skaria


"ROPL" wrote:

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.
--
Kel