Different Color

I am stumped as to change color based on color or based on number.
Let me explain,

A B C D E
1 5 1 2 7 8
2 22 11 44 13 27

In row 1 -- 1 & 2 would be colored light gray (15)
Also, in row 1 -- 7 & 8 would be colored light grey (15)
But because 1&2 and 7&8 are contiguous (side by side)
who to I make 7&8 automatically a different color say (19) a lite yellow.
And if and other sequence id found on that row to assign another color.

Then to check and assign the next row until the range is empty.
My question above rests on two of the same colors.
Or should color change on the change in value?

Any ideas. Thanks for looking at the question.





.

Relevant Pages

  • sequential numbers
    ... update the number sequence. ... You cannot drag the auto numbering facility ... across cells that you want to remain empty of course, ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: design - help
    ... file contains varying data, empty, numeric, text ... > I hear what your saying, but for this snippet I just want to ... Assuming that your sequence ...
    (perl.beginners)
  • RE: Adding info to query
    ... I'll try and give you an example to what I mean, it could be that the prev ... also, what if the first record is empty, there will be no previous record. ... Function LookForLastDate(IdFieldName As Double, DateFieldName As Variant) ... >>> Mike J ...
    (microsoft.public.access.queries)
  • RE: Adding info to query
    ... it sort of makes sense now. ... > compile error. ... >>> also, what if the first record is empty, there will be no previous record. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: double blank lines for index
    ... > and Set 2 are empty _before_ the double blank lines. ... Just like any sequence of at least one blank character ... you have to make sure each dataset consistes of at least one ...
    (comp.graphics.apps.gnuplot)