View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.