Hi I require a code that colour's tabs red if they contain a number >0 and colour's the other tabs that contain a number = 0 green. Example: Richard 1 = Red, Paul 0 = Green, Peter 5 = Red, Ozgrid 0 = green.
Finally if possible I have 3 tabs (all named) that I wish NOT to colour.
All of the tabs that I would like coloured would have been created automatically by VBA form a pivot table.
thanks in advance
Richard