A visitor asks

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

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 ( http://www.auditexcel.co.za/DataValidation.html )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.