Hi I am working in excel 2007.
I have to columns filled with dates down to row 35. I want to set the
background of the cells to red if the dates shown are less than today. I can
get this to work for one cell with this formula:
=$D$2<=TODAY()
So far I have been creating a new rule for each cell. Once I got down to
cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've
tried to set one conditional format for all the cells but then this sets all
the cells background to red (which shouldn't happen as most of the dates are
in the future so far). Can anyone help me out please?