View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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?