Cell formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make a range of cells say A2:U22 be bold according to the contents of a cell that is not within that range
i.e. Cell B6 contains text "Off" then the range of cells A2:U22 would be formatted in bold text. I haven't seen a way to do this easily using a conditional format, is there some type of Worksheet function that I can call to do this
Thanks for any guidance.
 
No reason you can;t use conditional formatting.

Select A2:U22. Then, in the Conditional Formatting dialog, set:

Formula Is $B$6="Off"

and set the font to bold.

BTW, how is B6 not within the range A2:U22?

--

Vasant

Fleone said:
I would like to make a range of cells say A2:U22 be bold according to the
Click to expand...
contents of a cell that is not within that range.
i.e. Cell B6 contains text "Off" then the range of cells A2:U22 would be
Click to expand...
formatted in bold text. I haven't seen a way to do this easily using a
conditional format, is there some type of Worksheet function that I can call
to do this?
 
Fleone

Select A2:U22 and Format>CF

Formula is: =$B$6="Off" $ signs are necessary to anchor B6.

Format to Font>Bold

As an aside, B6 IS within the range A2:U22

Gord Dibben Excel MVP
 
Back
Top