LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Member
 
Posts: 84
Default

Quote:
Originally Posted by MRT View Post
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Text based on a formula Scully Excel Worksheet Functions 3 March 1st 09 05:16 PM
Conditional formula containing text and wildcard PMo Excel Worksheet Functions 3 August 27th 08 04:14 PM
conditional formatting - problem with text cell value from formula PBcorn Excel Worksheet Functions 2 April 18th 08 11:39 AM
Conditional formatting based on text within a formula Sarah Jane Excel Worksheet Functions 13 October 12th 06 04:12 PM
Can a conditional formula indicate "date added" next to a text? Earnest er Excel Worksheet Functions 2 September 7th 05 05:45 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"