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
Bookmarks