Conditional format, expand choices

Hey, I am trying make one cell have 10 background color choices instead of the standard 3. Eg, when the number "2" is entered in the cell it will turn red, when "4" is entered it will turn green, when "6" is entered it will turn blue, this will continue until the number "20" going up by 2's making 10 color choices for one cell.

This book will be used on a PC that is using Excel 2003. And all the research I have done says it can only be done by a macro. Any help would be much appreciated.

Your research shows the correct result. This forum has many examples for more than 3 conditional formats with VBA.

Search just Excelforum using Google

more than three conditional format site:excelforum.com

Hello JapanDave,

Here are two macro that you can added to the workbook. One is a Worksheet_Change() event and the other handles the color matrix. You may need to make change to the color matrix to match what you want.

Worksheet_Change() Macro

Please Login or Register  to view this content.

Module1 - Macro to Load the Color Matrix

Please Login or Register  to view this content.

Hello JapanDave,

Sorry about the late response. I had a project to complete before going to bed. To answer your question, you need only change the Worksheet_Change event code. Here is the code for sequential numbers. This will respond to values from 1 to 10

Worksheet_Change() Macro

Please Login or Register  to view this content.