How to: Highlight Column based on a search criteria?

[Minilin]

Hiya,

I would like to be able to highlight a column if a cell equals a specific week number.

Please see attached picture for an example of what I am looking to achieve.

I want to be able to type in the week number, in this example 52, and the related column then highlights in grey.

Assuming this will need some sort of conditional formatting as well as a formula.

Tried using a formula to highlight column based on specific number but I couldn't get it to work and I now can't find the version with the formula in it

Thanks in advance

 

[Fluff]

Select the range you want it to work on, like E6:BD50 then conditional format, new rule, use a formula & use

=E$7=$C$3

 

[Minilin]

Select the range you want it to work on, like E6:BD50 then conditional format, new rule, use a formula & use

=E$7=$C$3

Thank you, knew it would be simple enough!

 

[Fluff]

You're welcome & thanks for the feedback.