you can try to use the conditional formatting, it will not effect to any formula in the sheet.
it will highlight in row 2
For Today
1. Highlight row 2
2. conditional formatting > New Rules... > Use formula to determine...
3. put in this formula
4. Modify the format you want.
5. select ok
For Tomorrow
repeat 1 and 2 above,
3. put in this formula
4. and 5. same with above
Main condition/requirement: the date is date format (it can check by change the format to number, it will become 5 digits numbers and start with 4)
your computer Date is function well....
PS: Please use different format to differentiate. (I common use difference fill in color)
erm.... after read again the question. I am misunderstand....
ok, here the formula,
in B1,
in B2
Bookmarks