Audrey,

Why not use Conditional Formatting? Check help for details, and post back if
you get stuck.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Audrey Ng" wrote in 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!