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

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

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

Select cell f52. Format > Conditional Formatting. Use the drop-downs to
create the condition: Formula Is, =(p50>0). 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

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

=P50>0

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