Cell formatting

Occasional Visitor

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


1 Reply


Perhaps by using VBA code, but that would be cumbersome. Conditional formatting is the best option in my opinion.