Forum Discussion
Conditional Formatting - Highlighting sheet names linked to a value in a cell
Hello, Oliver
Thank you for your reply, but I think I have done something wrong here.
F12 contains the formula =SUMPRODUCT(COUNTIF(INDIRECT("'"&I2:I61&"'!C7"), E12)) which is returning that there is 1 instance of the MODEL# from E12 occurring in my 60 sheets, in this case it occurs in sheet "110". I'd like to be able to click on a cell and have "110" highlighted in column "I". I tried inserting your formula into cell H12 to achieve this but there is something wrong with the formula. Have I put it in the wrong place or typed it wrong?
You are welcome. In your screenshot the formula refers to cell F12 instead of E12. However the formula is supposed to do what i've suggested in my last reply. I forgot to mention that it's an alternative solution.
In the attached file you can select a cell in range F12:F18 and then cells in range I2:I61 are highlighted according to the conditions. This is only possible with VBA and should return the result you are looking for. You can select cells in range F12:F18 with the up and down and left and right keys of the keyboard as well.