I have used the method in http://www.mrexcel.com/tip054.shtml
to set up cells showing due dates. However when a cell contains nothing it defaults to the first conditional format (red). Is there a way to use the last available conditional format statement to make empty cells colourless and any other date a third colour say yellow
to set up cells showing due dates. However when a cell contains nothing it defaults to the first conditional format (red). Is there a way to use the last available conditional format statement to make empty cells colourless and any other date a third colour say yellow