I am constructing a workbook comprising of several pages. The first sheet which I call Index contains a list of sheet names which are hyperlinked to sheets which follow the index sheet. One column called Live issue in each of the following sheets contains a Yes or No as part of the details entered in each of the rows. What I want to do is to be able to display on the Index sheet in the cell to the right of the hyperlink a colour red to indicate if any of the cells in the Live issue column contain Yes or green if none of the cells contain Yes. I am using excel 2007.
Any help would be greatly appreciated.
Thanks
John
Bookmarks