you would probably need to setup the series using a range of IF statements - so if the date changes then the range series changes and so the colour
see example attached
change the date in cell A2 and then copy down and you will see the colours change based on todays date
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Its beautifully done! How do you get the colour to change? it's not a macro!Originally Posted by etaf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks