- Jun 23, 2004
Actually a two part question. One sheet in a workbook is a testing sheet to see if certain conditions are met. I would like to have the Tab color turn Red if any of the Conditions are present. Currently the sheet has conditional formating for each condition and sets the color to yellow within the cell that is meeting that particular condition. 1) is there a way to populate a test cell that will put a "1" in place if any of the other cells are yellow. 2) if that test cell has a 1, have the tab color change to red?