You might also want to check out Conditional Formatting for that part as opposed
to VBA. Might be a better option.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"James Prontier" wrote in message
...
I am an Excel beginner, but learning a lot from the experts in this newsgroup.
My problem is simple - I have two cells that I am monitoring. If cell 2 is
larger in value than cell 1 (a1 < a2), then I need to "highlight" the the cell
next to them in Red. If the A1 < A2 condition exists, I call a UserForm and will
change the background color of that 3rd cell via an offset in the Userform. What
I don't know how to do is change the background color. I would appreciate any
help that can be offered. Thank you.

JP


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004