Conditional formatting on overtime hours
 

Excel 2003

I have a timesheet and have total number of hours worked in in p49 and hours
over 40 in p50.
I want to format f52 once p50 is greater than 0.00
Please help !
--
Thanks!
-Jennifer

Conditional formatting on overtime hours
 

Select cell f52 and go to conditional formatiing.
Choose Formula is in the drop down box and say
=P500

Choose the color you want the formatting to be. You can use the format
painter to apply this to other cells also.

"Jennifer" wrote:

Excel 2003

I have a timesheet and have total number of hours worked in in p49 and hours
over 40 in p50.
I want to format f52 once p50 is greater than 0.00
Please help !
--
Thanks!
-Jennifer

Conditional formatting on overtime hours
 

Select cell f52. Format Conditional Formatting. Use the drop-downs to
create the condition: Formula Is, =(p500). Then select the format you want.

"Jennifer" wrote:

Excel 2003

I have a timesheet and have total number of hours worked in in p49 and hours
over 40 in p50.
I want to format f52 once p50 is greater than 0.00
Please help !
--
Thanks!
-Jennifer

Conditional formatting on overtime hours
 

In cell F52, select Conditional Formatting, and switch "Cell Value Is" to
"Formula Is". Enter the formula:

=P500

Then select your formatting. That should do it.

HTH,
Elkar


"Jennifer" wrote:

Excel 2003

I have a timesheet and have total number of hours worked in in p49 and hours
over 40 in p50.
I want to format f52 once p50 is greater than 0.00
Please help !
--
Thanks!
-Jennifer