software

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
=P50gt;0

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

quot;Jenniferquot; wrote:

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

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

quot;Jenniferquot; wrote:

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

In cell F52, select Conditional Formatting, and switch quot;Cell Value Isquot; to
quot;Formula Isquot;. Enter the formula:

=P50gt;0

Then select your formatting. That should do it.

HTH,
Elkarquot;Jenniferquot; wrote:

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