hello,
I'm currently using the conditional formatting options for dates to highlight a date with a specific color if it references the following:
tomorrow = yellow
today = green
yesterday = red
When you choose the default options in Excel it doesn't actually spell out the formula to achieve these results. I'm asking for this hidden formula in case i wanted to eventually color a cell 2 days before or after today down the road sometime which Excel does not provide by default. Any help is greatly appreciated.
thank you!
Bookmarks