# Cell Colouring help

1. ## Cell Colouring help

Hi

im try to do some cell combination colour based on 6 cell, when excel detect first cell with same number willl combine into green colour. is there a way to do that?

5002.png

2. ## Re: Cell Colouring help

Greetings!, hope this helps!
Formula:

Applies to =\$B\$7:\$D\$7

Working example attached.

3. ## Re: Cell Colouring help

Originally Posted by Kirkules;5340626
[FORMULA
The third factor \$B7=\$D7 can be removed!

4. ## Re: Cell Colouring help

will this code work like this way as well?

first formula
feeff.png

second formula
1ddw.png

5. ## Re: Cell Colouring help

Using the file attached to post #2, this as the rule for B7:

=AND(B7<>"",\$B7:B7=\$B7)

Applies to range: =\$B\$7:\$S\$48

Make this range as big as you need.

If you want help with the second query, attach a workbook with sample data yourself, please.

6. ## Re: Cell Colouring help

Hi. AliGW

i've successfully connect the cell colour according i want but i failed to make the second query
2122.png

7. ## Re: Cell Colouring help

I have asked you to attach the workbook here - instructions are at the top of the page. I am not going to follow an external link - do as you have been asked, please. Thanks.

8. ## Re: Cell Colouring help

Sorry AliGW.

Here my attachment

9. ## Re: Cell Colouring help

I see you ignored my advice on the first problem - I suggested one rule, and you have four.

Second problem: explain the logic to the shading.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1