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
(Excel 2007 by the way)