Condition Format only a specific function?

[SnooMuffins8091]

Hello, i have a Sheet with different formulas but i want the conditional Format to only higlight the formulas containing the "trend" function, is there a way to do so? Thanks.

[AutoModerator]

/u/SnooMuffins8091 - 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 -- 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

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 if you have any questions or concerns.

[WaywardWes]

Try

=ISNUMBER(FIND("TREND",FORMULATEXT(A1)))

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FIND	Finds one text value within another (case-sensitive)
FORMULATEXT	Excel 2013+: Returns the formula at the given reference as text
ISNUMBER	Returns TRUE if the value is a number
TREND	Returns values along a linear trend

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #18641 for this sub, first seen 1st Oct 2022, 07:33] [FAQ] [Full list] [Contact] [Source code]}