I have a workbook that contains 27 worksheets, named "1" through "27". The colors on worksheet "1" change depending on some conditional formatting that I used on that page. I would like cells "A1:O30" on worksheets "2" through "27" to mirror the background colors of "A1:O30" on worksheet "1" ... 100% of the time. I have been searching for a solution all over the web to no avail. Thanks in advance to any guru who might be of assistance!
Last edited by jonvanwyk; 12-28-2011 at 12:24 PM.
Can you not just apply the same conditional formatting to those sheets? Code to read CF is not that simple in any version pre-2010 - though for basic colours, you can use something like Chip's code here.
Remember what the dormouse said
Feed your head
I could just use the same CF on the other 26 worksheets....but that is a lot of work (especially if I am later instructed to change the colors associated with the conditional formatting). So, I am trying to be forward thinking so that if the colors ever need to change, then I can just change the one worksheet and the others will automatically follow suit. Short term misery for long term benefit?
Nevermind. I have taken a different path, removing the CF coloring of those worksheets and am making the colors static.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks