Hi,
I am building a spreadsheet that references a date and conditionally formats it based on the amount of days between it and one year. If it is more than 6 months from "today" it will turn green, less than 6 months from today it'll turn yellow, and if its today or earlier it will turn red. My problem is I would like it to not display a colour, and not display 31-DEC-00 as it currently does. Is there any way to have it remain blank, and not turn red? Please let me know if I am missing something, or if it is not possible.
Thank you
Bookmarks