Have you learned nothing from the "King and I"?

value is 1, blue if the cell value is 2 etc etc

et cetera, et cetera, et cetera

(in my best Yul Brynner voice)

<gd&r

Bob Phillips wrote:

so why didn't you say?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tim" wrote in message
...
As you have said, only cover 3 conditions using
Conditional formatting - I need about 10.

to clarify - users selects a range of cells, each
containing a number
runs macro - checks the value of each cell in the range,
then gives it a colour depending on what the cell value
is.

TIA
tim

--

Dave Peterson