Text Box with conditional formula
 

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

Text Box with conditional formula
 

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

Text Box with conditional formula
 

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" wrote in message ...
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

OK, the previous instructions takes a picture of the cell. I need to have a text box, not a picture. A text box gives you formatting capabilites. Ideas anyone?

Text Box with conditional formula
 

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,