Bold font if statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drb - 08 Mar 2008 14:41 GMT

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?

Reply to this Message

Pete_UK - 08 Mar 2008 16:25 GMT

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

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

Reply to this Message

drb - 09 Mar 2008 06:07 GMT

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

On Mar 8, 2:41 pm, "drb" <drbur...@pacbell.net> 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?

Reply to this Message

Pete_UK - 09 Mar 2008 22:01 GMT

You're welcome - thanks for feeding back.

Pete

> Exactly what I was looking for. Thank you.
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Reply to this Message