Hello,
I have a multiple sheet workbook. I would like to highlight given cells with the value of 0 when the current date reaches a given date. IE: On the December worksheet I want a cell to highlight after December 15th if it contains 0., I have a worksheet for each month, So I will be using this formatting multiple times (with a different date for each month).
I have dug and dug, and I can't nail this one down. I have tried using =today() and Date functions, and I cannot get it right.
Any help, O masters of Excel?
Bookmarks