I am trying to use conditional formatting within a column, filling the cells in with bright red IF the date is less than "today" and the cell is not blank.
I understand =today() and <>"" but for whatever reason this is giving me problems.. dates that are not supposed to be in the range are highlighted.. or only blank dates are highlighted.. etc.
I originally wanted to use this within a filtered range but reverted back to non filtered just to figure it out. i know its something simple. Please help haha
Bookmarks