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!