A not too dissimilar question asked recently which may / may not be of interest to you ?
http://www.excelforum.com/excel-prog...condition.html
in reality you will need to adapt the above based on
a) when you want the tab colour to update
b) what governs values within range Z4:Z86 changing ?
ie do these cells contain formulae or are they updated via manual entry ?
Bookmarks