You could simply use conditional formatting:

format / conditional formatting


-----Original Message-----
Hi everyone,

I have an excel spreadsheet that looks like this:

Dr.A Dr.B
Dr.C
Total Wkld 100 100
100
Avail.Wkld
Weight Amt Left
Program A 100
Program B 100
Program C 100

So Avail. Wrkld and Amt Left gets populated when inside
of the grid gets
populated.

If Avall Wkld is less than 0, I want to change the
background colour to
red. Same goes gor Amt Left. If it's greater than 0
then, just have the
background colour as white. I am thinking of using the
Worksheet_Change
event. Can someone help me code this?

Audrey

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.