Text Box with conditional formula

  • Thread starter Thread starter Keyrookie
  • Start date Start date
K

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
 
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;904284 said:
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
Click to expand...


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
 
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.
 
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.
 
Back
Top