View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default conditional formating if and And

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

€˛ROPL€¯ ezt Ć*rta:

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