Highlight multiple cells based on value of one specific cell

[thekamel]

Hello,

I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck:

Thanks in advance for any assistance!

 

[JamesCanale]

Make the formula:
=$K$32

That's it. No ="TRUE". TRUE becomes a datatype in excel.

 

[thekamel]

Make the formula:
=$K$32

That's it. No ="TRUE". TRUE becomes a datatype in excel.

Thank you so much! I knew I had to be over-thinking it!