3 + the default format, so 4 in total.
--
David Biddulph


"Jim Thomlinson" wrote in message
...
Conditional formats are limited to 3 different formats in XL2003 or less.
So
you can end up with a max of 3 different colours...
--
HTH...

Jim Thomlinson


"andiam24" wrote:

Hello,

I would like to set a conditional format to color each unique value a
different color. It will also be applied to multiple occurences of the
value.
The problem is that the values are dynamic and may not always be the same
number of occurences, in the same cell, etc. I have used the formula
IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the
occurences
but creating a conditional format has proven out of my league! Please
help!
And thanks!!