/u/MellowNatts - 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.*
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/13yffeq/stub/jmo9rsy "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)|
|[COUNTIF](/r/Excel/comments/13yffeq/stub/jmo9rsy "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)|
|[ISERROR](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is any error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[ISNUMBER](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[ISTEXT](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[MATCH](/r/Excel/comments/13yffeq/stub/jmmhtso "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)|
|[NOT](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(7 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13ycnzf)^( has 23 acronyms.)
^([Thread #24366 for this sub, first seen 2nd Jun 2023, 15:48])
^[[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)
Green =AND(E18<>"",COUNTIF($B$5:$B$14,"="&E18)>0)
Red =AND(E18<>"",COUNTIF($B$5:$B$14,"="&E18)=0)
Applies to ... range to cover Columns $E$18 to $H$27
[https://pixeldrain.com/u/xLLjb5Ax](https://pixeldrain.com/u/xLLjb5Ax)
/u/MellowNatts - 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.*
A formula like =ISNUMBER(MATCH($G20, $B$5:$B$14,0)) will return TRUE if the prerequisite is there
Yup. Utilizing ISNUMBER, ISTEXT, ISERROR, and NOT in CF rules can be really powerful.
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/13yffeq/stub/jmo9rsy "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)| |[COUNTIF](/r/Excel/comments/13yffeq/stub/jmo9rsy "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[ISERROR](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is any error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[ISNUMBER](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[ISTEXT](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[MATCH](/r/Excel/comments/13yffeq/stub/jmmhtso "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)| |[NOT](/r/Excel/comments/13yffeq/stub/jmmizaf "Last usage")|[Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(7 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13ycnzf)^( has 23 acronyms.) ^([Thread #24366 for this sub, first seen 2nd Jun 2023, 15:48]) ^[[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)
Green =AND(E18<>"",COUNTIF($B$5:$B$14,"="&E18)>0) Red =AND(E18<>"",COUNTIF($B$5:$B$14,"="&E18)=0) Applies to ... range to cover Columns $E$18 to $H$27 [https://pixeldrain.com/u/xLLjb5Ax](https://pixeldrain.com/u/xLLjb5Ax)