![]() |
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. |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com