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.
|