How to make a cell font bold according to adjacent cell's value?

[Artemisia1984]

Hi everybody,

I'm using this forum for thee first time so I will try to explain my problem as clear as possible:
My data consists of three columns.
I want to make the font of the values bold whenever the value of the adjacent cell (on the right) has a value below 1 (or whatever).
Is there way of accomplishing this?

thanks in advance for your replies!

Philippe

 

[Fazza]

hello, Philippe

Excel has 'conditional formatting', ALT-O-D

So you can enter a formula like =$d1<1

or maybe =$d1<$e1
when the comparision is against the adjacent cell
or even very complex formulas

and when the condition is true a format you specify applies (to the cells with the conditional formatting). This can be to make the font bold

Excel help refers. OK?

If you have a further question, please advise your Excel version. regards, Fazza

 

[Artemisia1984]

hello, Philippe

Excel has 'conditional formatting', ALT-O-D

So you can enter a formula like =$d1<1

or maybe =$d1<$e1
when the comparision is against the adjacent cell
or even very complex formulas

and when the condition is true a format you specify applies (to the cells with the conditional formatting). This can be to make the font bold

Excel help refers. OK?

If you have a further question, please advise your Excel version. regards, Fazza

Hi Fazza,

thanks a lot for your help.
The formula you suggested worked for one cell only...I'm having some troubles applying it to a complete column.
This is what I did: selected the complete column A, chose conditional formatting, made a new rule using a formula, entered =$B:$B>1 (by selecting the adjacent row).
But this didn't seem to work...
Can you help me out with what went wrong?

Thanks a lot in advance,

Philippe

 

[Fazza]

sure, Phillipe

I wonder what version of Excel you're using as I think since Excel 2003 there have been subtle changes to conditional formatting.

Maybe selecting the whole column is complicating the application of the conditional format (in Excel versions since 2003)? Instead of selecting all column A, suggest you select from A1 to as far as you need the format (or someways past the last required row even). You could even go to the worksheet's last row. The point being the selection is A1:Axx instead of starting with an entire column. (If this does overcome the difficulty then it seems to me that Excel conditional formatting needs to be fixed up a little by Microsoft.)

When you go to enter the formula, be sure it is relative to the active cell. You may see it identified in the name box at the top LHS. So, if the active cell is A1, when you enter the formula it will be =B1<1

And if the active cell is A1000, then the formula you enter is =B1000<1

Excel will automatically make the formula apply correctly - for the cell one to the right - for the entire range that you selected when starting.

How is that?

 

[Artemisia1984]

sure, Phillipe

I wonder what version of Excel you're using as I think since Excel 2003 there have been subtle changes to conditional formatting.

Maybe selecting the whole column is complicating the application of the conditional format (in Excel versions since 2003)? Instead of selecting all column A, suggest you select from A1 to as far as you need the format (or someways past the last required row even). You could even go to the worksheet's last row. The point being the selection is A1:Axx instead of starting with an entire column. (If this does overcome the difficulty then it seems to me that Excel conditional formatting needs to be fixed up a little by Microsoft.)

When you go to enter the formula, be sure it is relative to the active cell. You may see it identified in the name box at the top LHS. So, if the active cell is A1, when you enter the formula it will be =B1<1

And if the active cell is A1000, then the formula you enter is =B1000<1

Excel will automatically make the formula apply correctly - for the cell one to the right - for the entire range that you selected when starting.

How is that?

Hi Fazza,

this worked out just fine.
Thanks a lot for your help!

Kind regards,

Philippe

P.S. I'm working on Excel 2010 (version 14.0)

 

[Fazza]

you're welcome, Phillipe