Bold a range if certain criteria is met.

[chad13]

How do I make a range bold (or change color) if the column heading meets certain criteria? Ex. If A10="YES", then I want the range A11:A20 to change to bold.

 

[inarbeth]

On 2002-10-15 08:55, chad13 wrote:
How do I make a range bold (or change color) if the column heading meets certain criteria? Ex. If A10="YES", then I want the range A11:A20 to change to bold.

You can do this easily using conditional formatting. Select the range A11:A20 and select Format, Conditional Formatting. Choose Formula is and type: =$A$10="YES"
Select Format and apply the bold font.

 

[chad13]

Thanks, that function works great!

On 2002-10-15 08:59, inarbeth wrote:

On 2002-10-15 08:55, chad13 wrote:
How do I make a range bold (or change color) if the column heading meets certain criteria? Ex. If A10="YES", then I want the range A11:A20 to change to bold.

You can do this easily using conditional formatting. Select the range A11:A20 and select Format, Conditional Formatting. Choose Formula is and type: =$A$10="YES"
Select Format and apply the bold font.