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?

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

On Mar 8, 2:41*pm, "drb" wrote:
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?

Exactly what I was looking for. Thank you.

"Pete_UK" wrote in message
...
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

On Mar 8, 2:41 pm, "drb" wrote:
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?

You're welcome - thanks for feeding back.

Pete

On Mar 9, 5:07*am, "drb" wrote:
Exactly what I was looking for. Thank you.

"Pete_UK" wrote in message

...
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

On Mar 8, 2:41 pm, "drb" wrote:



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?- Hide quoted text -

- Show quoted text -