Conditional Formatting Dates

K

Katie Schertzing

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
 
L

Luke M

CF formula for A1:
=OR(ISBLANK(A2),AND(A1<TODAY(),ISNUMBER(A1)))

CF formula for A2:
=AND(ISNUMBER(A2),A2<=A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting in excel 2007 1
Conditional formatting dates 2
conditional formatting based on a different cell 2
conditional formatting date and blank cell 3
conditional formatting 7
Excel High lightng dates in future, today and past 1
copying conditional formats 2
Conditional Formatting for multiple criteria 1

Top