for example,

1. input <that date into cell B1
2. select cell A1
3. On the <Format menu, click <Conditional Formatting.
4. click <Formula Is and then enter the following formula.
=NOW()=$B$1
5. Click the <Format and select the desired style.

--
MRT

"Keyrookie" wrote in message ...

Thanks MRT, that helped, but I need help on another formula. Here is
the formula in cell A1 =(WEEKDAY($A$1)=1)*A1
I need the cell to reformat if that date is NOW(). I'm thinking I'll
need an IF formula but I can't work it out. Any suggestions?


MRT;904284 Wrote:
is it ok for your requirements?

1. select the cell A1, and press Alt e c
2. select any cell, hold down SHIFT key and press Alt e N
3. use this shape as a text box.
4. set the conditional format at the cell A1 according to your
condition.

HTH
--
MRT


"Keyrookie" wrote in message
...-

Hey all,

Is there a way to conditionally format a text box? I have a
calendar
that has text boxes associated with the cells and I want the text
boxes
to reformat when conditions are met.

Thanks for your help,