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

I think then instead of using absolute row, column, you can try to use a
Named Range. Whenever, your total row changes, change the named range and I
hope it should work.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mitchell_Collen via OfficeKB.com" wrote:

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

I am confused about how to name a range. Do you mean naming a range 'total'
and then referring back to the formula where the value is = 'total' and the
column number is the active column number?
I am really new to this.
Thanks, Misty

Pranav Vaidya wrote:
I think then instead of using absolute row, column, you can try to use a
Named Range. Whenever, your total row changes, change the named range and I
hope it should work.

Thanks for your reply.
The row willl change as more employees are added and deleted. Do you know how
[quoted text clipped - 16 lines]

Thanks, Misty

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