Copy Format in multiple tabs based on text matching master list

koivusea
koivusea used Ask the Experts™
on
I have a spreadsheet with a master list (class titles) which is color coded based on the class title status (done with conditional formatting).  On my Site 1 and 2 tabs I would like the class titles to be color coded the same as it is on the master list and changed as the master list is updated.

Does it need to be done with VBA?  Any suggestions?

Thanks,
Ron
Conditional-Formatting-Sample.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Please find the attached workbook.
The Sheets Site1 and Site2 contain Worksheet Activate Event Code, so once you activate these sheets, Classes will be formatted as per the condition set on Master List.
Conditional-Formatting-Sample.xlsm

Author

Commented:
Thanks so much sktneer.  That is exactly what I need!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome koivusea!
Glad I was able to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial