View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Katie Schertzing Katie Schertzing is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting Dates

I am attempting to highlight past due dates (I am horrible with the formula's
and can not seem to figure out how to NOT highlight if there is no
information in the cell's)

A1=Planned date and A2=Completed date

Conditions I am trying to figure out
1. Would like A1 to highlight RED if less than Now and A1 is NOT BLANK or A2
is BLANK
2. Would like A2 to highlight green if filled out and less than or equal to A1

Thanks anyone that can help!!!
Katie