Thanks for your reply.
The row willl change as more employees are added and deleted. Do you know how
to sum a column that is dynamic?
Thanks, Misty

Pranav Vaidya wrote:
Select the entire column
I assume your total is on row 14. You can change it as per actual total line.
Go to Conditional formatting and select 'formula is'
type in this formula '=IF($B$14200,TRUE,FALSE)'
select the color to hightlight.

This will highlight the entire column, when value in B14 is more than 200.
Please adjust this formula as per your worksheet.

HTH,
Hi Everyone.
Please help me. I am trying to figure out how to write a conditional
[quoted text clipped - 14 lines]

Thanks, Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200709/1