 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008VB code
Hello, I have sheet that I am wanting to enter Monday to Friday in cells manually. I want the Interior.ColorIndex to be ruled by the actual day that it currently is. I want to regulate that by today=() and format the value as dddd to give me the day. How do I write the code to tell it that I only want the Interior.ColorIndex to report the actual day? Hope that makes sense, Any help is appreciated. Andrew A bit more detail would be helpful  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello, > I have sheet that I am wanting to enter Monday to Friday in cells [quoted text clipped - 12 lines] > > Andrew Lets say in cell B1 I want to enter Monday B1 Monday B2 Tuesday B5 Wednesday B7 Thursday B8 Friday These will be input manually and can differ. I want to make the cell colour change according to the actual day. I have a VB script that controls the cells according to what is input e.g.. Case Is = "PT", "pt": .Interior.ColorIndex = 15 Hope that explains it a little better? Andrew A bit more detail would be helpful SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello, > I have sheet that I am wanting to enter Monday to Friday in cells [quoted text clipped - 12 lines] > > Andrew Conditional formatting as I said with a formula of =B2=TEXT(TODAY(),"dddd") Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Lets say in cell B1 I want to enter Monday > B1 Monday [quoted text clipped - 32 lines] >> >> Andrew Oooohhh clever !!! I like that Bob. Thank you very much. Andrew Conditional formatting as I said with a formula of =B2=TEXT(TODAY(),"dddd") Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Lets say in cell B1 I want to enter Monday > B1 Monday [quoted text clipped - 32 lines] >> >> Andrew Use conditional formatting. Select the cells, say B2:F2, and then Format>Conditional Formatting. Set Condition 1 set to Formula Is, and a formula of =B2=TODAY(), and set a pattern colour. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hello, > I have sheet that I am wanting to enter Monday to Friday in cells [quoted text clipped - 12 lines] > > Andrew |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.