Quote:
Originally Posted by MRT
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,
KR
|
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?
KR