I need a conditional formatting formula that will work for a complete column with the following criteria.

Looking at row 5 for example:

If column H is empty then format column G

Format should beâ€¦..if the date in column G is before todays date then cell fill for G5 should be redâ€¦if its after todays date cell fill for G5 should be green

Thanks

(Excel 2007 by the way)

Looking at row 5 for example:

If column H is empty then format column G

Format should beâ€¦..if the date in column G is before todays date then cell fill for G5 should be redâ€¦if its after todays date cell fill for G5 should be green

Thanks

(Excel 2007 by the way)

Formulas are

=A1<Today()

and =

A1>Today()

CondFormat.xlsx

brandon

CondFormat.xlsx

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.