• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get 150 selected values to assume a unique color

In an excel worksheet are 250 values.
150 values are active. The rest are filtered out.
Every time a active value is selected it is also given a color for ease of identification.
The color can be the same for all 150 cells.
But since Excel provides millions of colors i prefer to use a unique color for each cell.
Can anybody please enlighten.
Thank U.
 
Of course it can be done
But
I would really question what value having 150 cells of different color will achieve
I would stick with either having them all the same color or zebra striped
 
Back
Top