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