Bold font if statement

[drb]

A column of numbers is calculated in if statements based on other column
numbers is same row. Want to bold the font if a number is greater than 4 in
excel 2002. How can I do this?

 

[Pete_UK]

You can't do that as part of your formula, but you can do it with
conditional formatting. Highlight the cells that this needs to be
applied to (for example, F2:F10) and click Format | Conditional
Formatting. Then in the Pop-up it should have selected Cell Value Is
in the first box, in the second box set it to Greater Than, and in the
3rd box enter 4. Then click on the Format button and click on Bold,
then click OK and OK again.

Hope this helps.

Pete

 

[drb]

Exactly what I was looking for. Thank you.

You can't do that as part of your formula, but you can do it with
conditional formatting. Highlight the cells that this needs to be
applied to (for example, F2:F10) and click Format | Conditional
Formatting. Then in the Pop-up it should have selected Cell Value Is
in the first box, in the second box set it to Greater Than, and in the
3rd box enter 4. Then click on the Format button and click on Bold,
then click OK and OK again.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Exactly what I was looking for. Thank you.


You can't do that as part of your formula, but you can do it with
conditional formatting. Highlight the cells that this needs to be
applied to (for example, F2:F10) and click Format | Conditional
Formatting. Then in the Pop-up it should have selected Cell Value Is
in the first box, in the second box set it to Greater Than, and in the
3rd box enter 4. Then click on the Format button and click on Bold,
then click OK and OK again.

Hope this helps.

Pete



- Show quoted text -