Text Box with conditional formula

[Keyrookie]

Hey all,

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

Thanks for your help,

K

 

[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

 

[Keyrookie]

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 you
condition.

HTH

Thanks MRT, that helped, but I need help on another formula. Here i
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'l
need an IF formula but I can't work it out. Any suggestions?

K

 

[MRT]

2. select any cell, hold down SHIFT key and press Alt > e > N

This procedure is based on excel 2003, if you are using 2007 ...

2. On the Home tab, in the Clipboard group, click the arrow below Paste,
click As Picture, and then click Paste Picture as Link.

 

[MRT]

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.