How to Highlight Each Column-Heading of the Active Row When The Corresponding Cells Contain 'X'

[Eduard_Stoo]

Hi -

I have a list of company plant and would like to dynamically-highlight the column title as each active row is selected, based on that row containing an 'X'.

I've kind of got part-way there, but can't get it over the line... It works for the first line highlighted in the set, but nothing after that

The conditional format formula in the header row T1:AB1 is currently : =IF(AND(CELL("row")=ROW(T3)),T3="X"). I need to expand to incorporate the entire list, but not sure of the best methodology... they may be a simpler solution also! I would appreciate if anyone can guide me on this one! Thanks