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 ?