conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

Possibly you could use the Worksheet_Change(Byval Target
as Range) event.
In the VB editor select the worksheet in question and
dblclick it. Insert the event trigger and add your code
"ActiveCell.Interior.ColorIndex = number"

However, this will only fire for the given worksheet, so
youl' need to insert the coden in every ws. appliccable.
or you could somehow couple it with a workbook event.



-----Original 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
.

conditional formatting
 

yes that will do it. yes it is the on change event. but i
see problems. set up like you stated then cell will change
color on the first change. any change after that would
keep it the same color. is that what you want?

-----Original 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
.