Yes, it is possible. You haven't given very many specific needs for you
procedure, but the basic VBA statement for what you want to do would
be:

If worksheets(1).cells(1,1).value0 then
worksheets(1).tab.colorindex=24

Change the worksheets() index to what you need, the cells reference to
the cell with the total in it, and the colorindex value to whatever
color you want. This statement could be placed inside a loop that
loops through any/all worksheets in the workbook. The procedure could
be associated with a button that you click to initiate the procedure,
or it could be placed in an event procedure so it runs automatically.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=486959