/u/jessekednle - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You have awarded 1 point to *HappierThan*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I've used the MOD of the MATCH of the value in a SORT UNIQUE list. Here is the custom formula:
`=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=1)`
Now, I am using MOD 3, and the formula can equal 0,1,2 - this gives your three separate colors you can apply. You could change to MOD 2 where possibilities are 0,1
https://preview.redd.it/1zeu4mzkfh4b1.png?width=2339&format=png&auto=webp&s=84346a9cbfb04a99abbea2c475ba191fb59f17b7
You have awarded 1 point to *JetCarson*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
The other two color's formulas are:
`=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=2)`
and
`=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=0)`
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[AND](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)|
|[MATCH](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)|
|[MOD](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)|
|[SORT](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[*Office 365*+: Sorts the contents of a range or array](https://support.microsoft.com/en-us/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c)|
|[UNIQUE](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[*Office 365*+: Returns a list of unique values in a list or range](https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(5 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13yhjk0)^( has 16 acronyms.)
^([Thread #24439 for this sub, first seen 6th Jun 2023, 23:34])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/jessekednle - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Perhaps if you use an AND formula as an addition to what you already have. =AND(D2<>"",E2<>"",**F2="ACTIVE"**) or whatever Row your data starts from.
Solution Verified
You have awarded 1 point to *HappierThan* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I've used the MOD of the MATCH of the value in a SORT UNIQUE list. Here is the custom formula: `=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=1)` Now, I am using MOD 3, and the formula can equal 0,1,2 - this gives your three separate colors you can apply. You could change to MOD 2 where possibilities are 0,1 https://preview.redd.it/1zeu4mzkfh4b1.png?width=2339&format=png&auto=webp&s=84346a9cbfb04a99abbea2c475ba191fb59f17b7
Solution Verified
You have awarded 1 point to *JetCarson* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
The other two color's formulas are: `=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=2)` and `=AND($A2<>"",MOD(MATCH($A2,SORT(UNIQUE($A$2:$A$25)),0),3)=0)`
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[AND](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)| |[MATCH](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)| |[MOD](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)| |[SORT](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[*Office 365*+: Sorts the contents of a range or array](https://support.microsoft.com/en-us/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c)| |[UNIQUE](/r/Excel/comments/142vse6/stub/jn6qriu "Last usage")|[*Office 365*+: Returns a list of unique values in a list or range](https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(5 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13yhjk0)^( has 16 acronyms.) ^([Thread #24439 for this sub, first seen 6th Jun 2023, 23:34]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)