This seems so simple but I've been wrestling with it all morning, to no avail.
Simple excel table of equipment, with a column for item status, each equipment item having a status of PASS or FAIL. All I want is that the cell at the head of the column (E1) changes to red, if anywhere down that column E there is a FAIL. Simply to flag up if there is a problem that needs dealing with.
Workbook attached. I know how to format the cell itself, and the row, no problem, but I simply cannot work out how to format a single cell based on something appearing somewhere within a range elsewhere in the table.
Your help very much appreciated!!
Many thanks
Bill
Bookmarks