not using conditional formating

[mikep]

I want to format several cell to produce a colour map of the set of information over 1000 cell in all. I can colour these cells using a macro to producr the colour map. This is slow, How can I conditional format each cell with 10 or so condtions? The conditional format on the drop down menu only has 3 conditions. Can a cell be formated using the if statment form the (ie =if cell value x the format cell colour red, if cell value y the format cell colour blue.

Any heple woulf be nice

 

[Iridium]

On 2002-10-28 08:41, mikep wrote:
I want to format several cell to produce a colour map of the set of information over 1000 cell in all. I can colour these cells using a macro to producr the colour map. This is slow, How can I conditional format each cell with 10 or so condtions? The conditional format on the drop down menu only has 3 conditions. Can a cell be formated using the if statment form the (ie =if cell value x the format cell colour red, if cell value y the format cell colour blue.

Any heple woulf be nice

As far as I know the limit for conditional formats is 3 with a pseudo 4th if you format the default cell colour as though it were another condition.

What you need to do is set up a macro on the worksheet which updates on entry of a value and then changes the cell colour. e.g.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dimension the colour parameter

Select Case 'Specify conditions
Case ? .ColorIndex = (colourindexnumber)
etc.
End Sub