Hi all,

I have been racking my own cells to try and format cells based on a date range but leave the cell blank if the cell has no information

Example

Make a cell green if >30days from todays() date, make cell amber if >30 but <14, make cell red if <14 - this I have managed to do unless the cell is exactly 30 days and the cell goes white (but thats a different issue)

So the only thing I would really like is for the cell to remain white if the cell contains no data.

Any help will be more than what I have now

Thanks

Dartherp