Bold a cell based upon data in another cell

[bronzeboar]

Hello,

I am working on a payroll report and I want to highlight overtime.
have a list of employees (over six hundred and some of them hav
multiple lines) and the hours they worked. Some rows are overtime:

_Name____OT___Hours___Rate____Total_
Sam 0 80 10.00 80.00
Sam 2 2 10.00 *30.00*

I am using IF statements in my Totals column to compute Hourly an
Salary wages.

example: =IF(D2="S",(K2/M2)*L2,IF(D2="H",(K2*L2)))

I would like to add a statement to the formula that would bold the dat
in the cell if the OT column is greater than zero.

Is this possible without getting into VBA? My time is limited and
may have to do without...

Thanks Much

 

[paritoshmehta]

Try using Conditional formatting on the cells,

select the column where you have the OT data and go t
"format>conditional formatting"

add a condition, e.g.

cell value is >> greater than >> 0

and then press the format button and select bold (and a differen
colour, if you want..)........

now whenever the cell has a value greater than 0, it will format it t
bold!


hope it helps you

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional format' for this.
See
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

 

[bronzeboar]

Hi Paritosh,

That works for the intitial OT column, but I would also like the total
column to have the OT hours (only) highlighted. So the totals wil
look like this:

$80.00
$70.00
*$60.00*
99.00
*15.00*

I am assuming a cell reference is needed (if D8>0 then BOLD)but
already have IF statements there (see original message) and canno
figure out how to incorporate a formatting into it.

Thanks for the response

 

[Frank Kabel]

Hi
formats can't be applied within formulas. Formulas can only return
values.
If you want to conditional format cells use Conditional Format

 

[bronzeboar]

Danke!

Hi
formats can't be applied within formulas. Formulas can only return
values.
If you want to conditional format cells use Conditional Format