Good day all,
I have two sets of conditional formating of cell colors for a single colum.
The first (which works as intended) turn the cell blue when within a certain date range. This date range is calculated based on adding a number of days to todays date.
The problem is that sometimes no date will be inputed in the refence cell for the formula. In this case the cell spits out a result for the formula of 2/4/1900. So an idea for a work around was to add a second conditional formatting rule that whenever this text was present (2/4/1900 resulting from not have a dates in the refence cells) the text would turn white along with the cell fill effectivly 'whiting out' the 2/4/1900 until a date was inputted in the refence cell.
However, this desired effect does not happen. I would guess it has something to do with the fact that when you select the field in question, you do not see actual text but the formula. Is there a way not to see the erroneous date of 2/4/1900 when there is no date in the refence cell or get this conditional formatting to work?
Thank you again.
Bookmarks