View Single Post
  #1   Report Post  
ldd
 
Posts: n/a
Default changing tab color conditionally


I have a Workbook that contains several pages. Each page represents a
different style of product. When my customer sends in an order I place
the order quantity in a certain named cell on the corresponding
worksheet. Is there a way that I can format the tab to change color if
the quantity of the named cell is greater than 0?

Thanks in advance.


--
ldd
------------------------------------------------------------------------
ldd's Profile: http://www.excelforum.com/member.php...o&userid=19157
View this thread: http://www.excelforum.com/showthread...hreadid=378510