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
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
Greetings!, hope this helps!
Formula:Please Login or Register to view this content.
Applies to =$B$7:$D$7
Working example attached.
The third factor $B7=$D7 can be removed!Originally Posted by Kirkules;5340626
[FORMULA
Quang PT
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi. AliGW
i've successfully connect the cell colour according i want but i failed to make the second query
2122.png
Last edited by capcomdevil; 06-02-2020 at 01:38 PM.
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.
Sorry AliGW.
Here my attachment
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.
Last edited by AliGW; 06-02-2020 at 01:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks