Conditional Formatting across sheets

A visitor asks

Is it possible to have conditional formatting between sheets/tab within the same workbook?

UPDATE: See a more detailed explanation on the latest Conditional Formatting across sheets post


Yes it can be done but you need to use named ranges to get it right.


If you watch our video clip on Data Validation ( )you will see that Named Ranges are used for certain of the lists. The exact same logic applies with Conditional Formatting. Give the reference cells a name and then within the conditional formatting wizard you refer to the name instead of the cell.


Hope this helps.