Hi Mark

A read of Chip Pearsons EVENTS may shed some light on your problem?

http://www.cpearson.com/excel/events.htm

John
"Mark" wrote in message
...
I am using Excel 97. I use conditional formatting on a regular basis, but
I
need to conditonally format more than 3 conditions.

Can I use the following code with something so that a cell is changed when
the value alters?

ActiveCell.Interior.ColorIndex = number

I assume that it's an 'onchange' function but I don't know how to do it!
Can anyone assist me, please?


-----
Mark