I am running Excel 2003 SP2 and have been trying to figure this out for 2
days. I have reviewed all of he postings and cannot get this to work. I have
a 4 sheet workbook. In cell A16 of the 3rd worksheet I have the formula
=IF(AND F10=2,F11=2,F12=2),"COMPLETED", "NOT COMPLETED") I also have
conditional formatting applied to this cell so that when "COMPLETED" is
displayed, the cell color is #4 (green) and when "NOT COMPLETED" is
displayed, the cell color is #3 (red). I would like to have the worksheet tab
color mirror this cell color. That way, when I am viewing any other
worksheet, I can simply look at the tab for the 3rd worksheet and determine
by the tab color if it is COMPLETED or NOT COMPLETED. I would really like to
get this working as I have been told it can't be done. Thanks in advance for
any help.