Forum Discussion
Highlighting sheet names if a specific value is found in that sheet.
Select H2.
On the Data tab of the ribbon, in the Data tools group, click Data Validation.
Select List from the Allow drop-down.
Click in the Source box and point to the list of unique appliance model numbers in column E.
Click OK.
Next, select the list of sheet names in I2:I61.
I2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=COUNTIF(INDIRECT("'"&I2&"'!C4"),$H$2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
When you select an appliance number from the drop-down in cell H2, the cells in I2:I61 corresponding to a sheet that contains the appliance number will be highlighted.