ExcelBanter - Conditional Formatting Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting Dates (https://www.excelbanter.com/excel-discussion-misc-queries/256699-conditional-formatting-dates.html)

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

Conditional Formatting Dates

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

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

Luke M
*Remember to click "yes" if this post helped you!*

"Katie Schertzing" wrote:

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