View Single Post
  #2   Report Post  
Keyrookie Keyrookie is offline
Member
 
Posts: 84
Default

Quote:
Originally Posted by MRT View Post
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