Sep 20 2022 07:20 AM
I have a spreadsheet which gets job detail information via a VLOOKUP formula from a central tab to approximately 20 other worksheets
For ease of viewing the cells for the job descriptons on the central tab are colour coded, but I need to get the same cell colour through to the other 20 worksheets
Other than using conditional formatting, which could be long winded, and may change if additional job descriptions are added, is there a way of formatting a cell to use the same colour as the cell where the data is stored
Many thanks
Chris
Sep 20 2022 10:07 AM
Perhaps by using VBA code, but that would be cumbersome. Conditional formatting is the best option in my opinion.