Make one cell bold if another cell 0
 

I need to make the value in A1 bold if the value in A2 is greater than zero.

Conditional formatting won't work because the result (bold) has to be
applied to the cell to which the test is applied.

The IF function won't work because value_if_true and value_if_false cannot
be formatting statements.

How can I do this?

Make one cell bold if another cell 0
 

conditional formatting works this way:
under conditional, select the drop down at cell is and change to formula is.
enter the following in the box:
=A20
then format...
Bold
"Ken Elder" wrote:

I need to make the value in A1 bold if the value in A2 is greater than zero.

Conditional formatting won't work because the result (bold) has to be
applied to the cell to which the test is applied.

The IF function won't work because value_if_true and value_if_false cannot
be formatting statements.

How can I do this?

Make one cell bold if another cell 0
 

Conditional Formatting will do that, in A1 apply CF using the formula option
and use the formula
=A20
Regards,
Alan.
"Ken Elder" wrote in message
...
I need to make the value in A1 bold if the value in A2 is greater than
zero.

Conditional formatting won't work because the result (bold) has to be
applied to the cell to which the test is applied.

The IF function won't work because value_if_true and value_if_false cannot
be formatting statements.

How can I do this?

Make one cell bold if another cell 0
 

Ken

You can do this with CF, highlight A1 and in CF just change the dropdown
from Cell value is to Formula is and enter

=A20

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Ken Elder" wrote in message
...
I need to make the value in A1 bold if the value in A2 is greater than
zero.

Conditional formatting won't work because the result (bold) has to be
applied to the cell to which the test is applied.

The IF function won't work because value_if_true and value_if_false cannot
be formatting statements.

How can I do this?