Format of one cell conditional on another

[RFJ]

Is there a way I can make a cell, eg B10, bold if another, say A10, is
greater than zero

 

[roly]

Hi,

You can use formulas in conditional formatting to make B10 bold if A10
is greater than zero.

Select cell B10, the Format menu and Conditional Formatting. Just
below Condition 1, select Formula Is and enter the formula =A10>0.
Select the Format button and select Bold in the Font Style list. You
can also Fill this down so A11>0 will be in B11 and so on.

Good luck,


Roly

 

[Guest]

Select cell B10. Go to the menu bar and select Format / Conditional
Formatting. In the Conditional Formatting panel click on the pull down arrow
next to "Cell Value Is" and chose "Formula Is". In the formula box to the
right type =A10>0 and then click on the Format button to select Bold, then OK
and OK...