Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |