 |
 | 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 / September 2004due dates
You've created a monster... is 3 the limit to the formulas in Conditional formatting? what if I wante next months colour to change as well :rolleyes The CF limit's 3, .. but you could try out these revised CF formulas (use same construct steps) Cond 1: =MONTH(TODAY())=MONTH(F5) Format cell fill as pale red (as before) Cond 2: =MONTH(TODAY())+1=MONTH(F5) Format cell fill as green? (this is for the additional next month's color) Cond 3: =AND(TODAY()>F5,F5<>0) Format cell fill as yellow (as before)  SignatureRgds Max xl 97 -- Please respond, in newsgroup xdemechanik <at>yahoo<dot>com --- > > You've created a monster... > is 3 the limit to the formulas in Conditional formatting? > what if I wante next months colour to change as well :rolleyes: |
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.