Home

Why is my formula not working?

%3CLINGO-SUB%20id%3D%22lingo-sub-921023%22%20slang%3D%22en-US%22%3EWhy%20is%20my%20formula%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-921023%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20select%20my%20worksheet%20A2%20to%20AF999%20select%20conditional%20formatting%20create%20new%20rule%20and%20use%20formula%20to%20determine%20which%20cells%20and%20input%26nbsp%3B%3CFONT%3E%3D%24AC%242%3D%22Wrong%20information%20word%20please%20check%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EWhat%20have%20I%20miss%20there%20are%20other%20rules%20in%20my%20worksheet%20they%20appear%20to%20be%20working%20be%20not%20this%20one%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-921023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-921498%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20is%20my%20formula%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-921498%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20your%20formula%20will%20apply%20conditional%20formatting%20to%20all%20cells%20A2%3AAF999%20if%20cell%20AC2%20contains%20the%20phrase%20%22Wrong%20information%20word%20please%20check%22.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20are%20you%20aiming%20to%20do%3F%20Could%20you%20post%20a%20sample%20Excel%20file%20or%20screenshots%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E
Highlighted
Linda A. Barnes
Occasional Contributor

I have select my worksheet A2 to AF999 select conditional formatting create new rule and use formula to determine which cells and input =$AC$2="Wrong information word please check"

What have I miss there are other rules in my worksheet they appear to be working be not this one 

1 Reply
Hi

So your formula will apply conditional formatting to all cells A2:AF999 if cell AC2 contains the phrase "Wrong information word please check".

What are you aiming to do? Could you post a sample Excel file or screenshots?

Thanks
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 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