How to turn a column green based on data entered in one cell

[Nelly3007]

Hello All,

Is there a way to turn a column green based on entering 'H' in the cells in row 5 please? I'm thinking it will just be a case of conditional formatting so have only attached a screenshot but can link to a live document as well if necessary

Many Thanks,

 

[Cubist]

Select the range. Conditional formatting determine using formula. Insert:

=J$5="H"

 

[Nelly3007]

Select the range. Conditional formatting determine using formula. Insert:

=J$5="H"

Hi Cubist,

So frustrating but so simple this has worked great, thanks so much!

Many Thanks,