Format of one cell conditional on another
 

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

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 =A100.
Select the Format button and select Bold in the Font Style list. You
can also Fill this down so A110 will be in B11 and so on.

Good luck,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401982

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 =A100 and then click on the Format button to select Bold, then OK
and OK...


--
Thanks,
TC


"RFJ" wrote:

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