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.

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.

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.

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.