Conditional formatting if cell contains, then format column

So I’m having a moment. I know I can do this but I can’t figure it out. So with the attachment, I want to set up conditional formatting based of the contents of A1:H1

If a cell in A1:H1 contains the word MAND, then that respective column would be highlighted yellow. So since A1 has MAND. Then A3:A12 would be highlighted yellow.

Originally Posted by daddylonglegs

Hello Kevrhof, try this,

Select the range A3:AH12 and apply this formula in conditional formatting

=A$1="Mand"

Apply required format

Note the $, that's required

Now any column with "Mand" at the top will be formatted

Ah brain fart I was doing it backwards. Make it a little more complicated, how can I do it and only highlight cells that contain TNG, if in that column one cell didn’t have TNG but MAND was at the top