Macro or conditional formatting to shade 4 liked numbers

**Larbec** · 09-29-2015, 02:42 PM

I'm wanting to look at different sheets and view at a glance a section of 4 numbers that are a like and shade them a different color. Is this possible or would it be a nightmare to figure out? If a nightmare please tell me and I'll continue to do it manually.

I'm not sure if it matters. These numbers have formulas in them from a linked sheet(s)

Here's an "example". It does not need to be these colors. As long as the matching numbers are the same. The cell location is accurate in the snip

Thank you so much for looking at this.

Attachment 422089

**FDibbins** · 09-29-2015, 04:49 PM

With all those colors in your pic, it is hard to see what *else* you want apply color to...or are those colors what you applied to your 4-count already?

Perhaps upload a small (clean) - PLAIN- sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**Larbec** · 09-29-2015, 06:33 PM

Thanks for replying and also asking for a file. As I was putting the file together and shading i realized it would be a lot to do for a Macro nd I would not want to place that much work on anyone. I have different Game sheets and each game has new numbers so some games may only consist of 8 different colors while others may require 10. I really have no clue until the game arises If a formula is possible to use in CF I can use that. That way I am the one doing the work load and the last thing I want to do is be a burden to anyone on here/ Ya'll are awesome at what you are doing and its much appreciated.

**Larbec** · 10-04-2015, 07:14 AM

I'm just going to use CF for sheets. It will take a while to do them but worth while. Thanks for your interest and as always have a wonderful blessed week