Home

Conditional Formatting based on Formula, Not Value

%3CLINGO-SUB%20id%3D%22lingo-sub-800979%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20based%20on%20Formula%2C%20Not%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800979%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20uses%20several%20INDIRECT%20formulas.%26nbsp%3B%20I%20would%20like%20to%20flag%20these%20via%20conditional%20formatting%20so%20I%20know%20which%20cells%20to%20update%20(i.e.%20a%20cell%20featuring%20any%20INDIRECT%20function%20turns%20red).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%26nbsp%3B%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-800979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Indirect%20Function%20Conditional%20Formatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-801173%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20based%20on%20Formula%2C%20Not%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-801173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F286940%22%20target%3D%22_blank%22%3E%40warrevar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20conditional%20formatting%20rule%20with%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DISNUMBER(SEARCH(%22INDIRECT%22%2CFORMULATEXT(A1)))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eassuming%20A1%20is%20top%20left%20cell%20of%20your%20range%3C%2FP%3E%3C%2FLINGO-BODY%3E
warrevar
Occasional Contributor

I have a workbook that uses several INDIRECT formulas.  I would like to flag these via conditional formatting so I know which cells to update (i.e. a cell featuring any INDIRECT function turns red).

 

Any suggestions?  Thanks!

1 Reply

@warrevar 

You may use conditional formatting rule with the formula

=ISNUMBER(SEARCH("INDIRECT",FORMULATEXT(A1)))

assuming A1 is top left cell of your range

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies