Hi there,
I have a workbook with 40+ worksheets. The first tab is a Table of Contents (TOC) listing the title of each data worksheet (tabbed at bottom of spreadsheet). The remainder of worksheets are data. All I want to achieve is to turn a Table of Contents cell RED using conditional...