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

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

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?

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,

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