If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with formula for bolding font
I need a calcualtion formula that will result in the bolding of a cell.
If cell A1 is less than half the amount of cell B1 then bold cell B1. example A1 = 50 B1= 110 = Bold B1 A1 = 50 B1 = 100 = nothing Thanks in advance for the assistance. |
#2
|
|||
|
|||
help with formula for bolding font
Hi,
Select A1 then Format|conditional format select Cell value is Less than enter this formula =$B$1/2 and select bold as your condition Mike "Roger" wrote: I need a calcualtion formula that will result in the bolding of a cell. If cell A1 is less than half the amount of cell B1 then bold cell B1. example A1 = 50 B1= 110 = Bold B1 A1 = 50 B1 = 100 = nothing Thanks in advance for the assistance. |
#3
|
|||
|
|||
help with formula for bolding font
Select B1. FormatConditional formatting, choose Formula is and in the formula box, enter =A1(B1/2)
Press Format, Font tab and select Bold. -- Kind regards, Niek Otten Microsoft MVP - Excel "Roger" wrote in message ... |I need a calcualtion formula that will result in the bolding of a cell. | | If cell A1 is less than half the amount of cell B1 then bold cell B1. | | example | | A1 = 50 B1= 110 = Bold B1 | | A1 = 50 B1 = 100 = nothing | | Thanks in advance for the assistance. |
#4
|
|||
|
|||
help with formula for bolding font
perfect thanks. Although I realized why questions was incorrect shortly
after I implemented the solution. What if I needed to bold a separate cell that has no numerical significances to the values of the cells that the formula is reading. Example: If cell B1 is less than half of Cell C1 then bold Cell A1. Sorry for the miscommunication. "Mike H" wrote: Hi, Select A1 then Format|conditional format select Cell value is Less than enter this formula =$B$1/2 and select bold as your condition Mike "Roger" wrote: I need a calcualtion formula that will result in the bolding of a cell. If cell A1 is less than half the amount of cell B1 then bold cell B1. example A1 = 50 B1= 110 = Bold B1 A1 = 50 B1 = 100 = nothing Thanks in advance for the assistance. |
Thread Tools | |
Display Modes | |
|
|