I am trying to create conditional formatting in Excel 2010.
I am trying to make the cell GREEN when the date is in the future and red is the date is the current date or in the past and nothing (i.e. white) is the cell to which the conditional formatting is applied is blank.
I have created the conditional formatting as shown however blank cells turn red? Could anyone suggest why this is?