I am trying to use conditional formatting on a range of data in Google Sheets. I want any given column’s formatting to depend on its column heading, which is either a number between 1-5 or the word “banned” (I run a consignment store and I’m updating my price book – the numbers represent how many prices I have found for a given type of clothing of a particular manufacturer). The relevant information for the condition is in row 2.

I am trying to use conditional formatting on a range of data in Google Sheets. I want any given column’s formatting to depend on its column heading, which is either a number between 1-5 or the word “banned” (I run a consignment store and I’m updating my price book – the numbers represent how many prices I have found for a given type of clothing of a particular manufacturer). The relevant information for the condition is in row 2.