How to apply changing conditional formatting to an array of columns

[Jaylo801]

Hello,
I am trying to apply conditional formatting to an array of data. Specifically, if data in a specific column g7:g87 is equal to the text value in g5, I want it to be green with green writing. I can easily do this for this one column. But actually I would like the same formatting to apply to columns H to AT, with the row numbers staying the same, while the column changes, so that the formatting applies to each individual column. Of course I can do this formatting operation 40 times but I'm hoping there is a quicker and easier way to do this.

 

[Jaylo801]

OK thank you for that. That explains the problem. I can't see the spaces unless I look at the actual box with the text value in it. Something strange must have happened when I exported it from MS Forms. I'll see if I can clean up the data to make it work. Your help is greatly appreciated.

 

[Jaylo801]

That is a great solution. I'll do it now. Thanks so much for your help. I would never have worked this out.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.
Good luck with the data clean-up!