default conditional formatting formula for dates

[wormssss]

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!

[popipipo]

Use the next formulas

day after tomorrow: =a2=today()+2
tomorrow =a2=today()+1
today =a2=today()
yesterday =a2=today()-1
day befor yesterday =a2=today()-2

[wormssss]

Thank you!

Apparently i was using the "$" in the formula which it didn't like.
It took a little tweaking but this will do the trick.
thank you again