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