Home

Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-355171%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355171%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20if%20there%20is%20a%20formula%20I%20can%20put%20in%20conditional%20formatting%20to%20highlight%20cells%20in%20red%20when%202%200's%20appear%20in%20a%20row.%20Please%20see%20my%20example%20file%20(I%20have%20highlighted%20cells%20that%20I%20would%20like%20to%20automatically%20appear%20in%20red%20with%20the%20formula)%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20formula%20I%20have%20tried%20in%20the%20past%20is%20highlighting%20not%20only%20the%200%20when%20it%20appears%202%20times%20in%20a%20row%2C%20but%20also%20any%20other%20digit%20if%20it%20appears%20twice.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20I%20have%20explained%20what%20I%20want%20to%20do%2C%20if%20not%2C%20I%20will%20try%20give%20more%20information.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355171%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355254%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355254%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Wyn.%20That%20looks%20like%20it%20should%20work%20as%20it%20works.%20I've%20just%20got%20to%20get%20it%20working%20in%20my%20original%20document.%20It%20seems%20to%20be%20thinking%20the%20M's%20and%20E's%20are%200's.%20I'll%20keep%20working%20with%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355202%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355202%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F289339%22%20target%3D%22_blank%22%3E%40H_Jones1985%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3Bgive%20ur%20question%20answer%2C%20but%20if%20u%20want%20before%20red%20highlight%200%20in%20twice%20or%20many%20appearance%20in%20data.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20912px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84032iE6472037CFD0854C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Esee%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355190%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355190%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F289339%22%20target%3D%22_blank%22%3E%40H_Jones1985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESomething%20like%20the%20attached%20file%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20877px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84030i8F067670D31477E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
H_Jones1985
New Contributor

I am trying to figure out if there is a formula I can put in conditional formatting to highlight cells in red when 2 0's appear in a row. Please see my example file (I have highlighted cells that I would like to automatically appear in red with the formula)

Any formula I have tried in the past is highlighting not only the 0 when it appears 2 times in a row, but also any other digit if it appears twice. 

 

Hopefully I have explained what I want to do, if not, I will try give more information. 

3 Replies

Hi @H_Jones1985 

 

Something like the attached file?

 

image.png

 

 

Hi @H_Jones1985 ,

 

@Wyn Hopkins give ur question answer, but if u want before red highlight 0 in twice or many appearance in data.

Capture.JPG

see the attached file.

 

 

Thanks Wyn. That looks like it should work as it works. I've just got to get it working in my original document. It seems to be thinking the M's and E's are 0's. I'll keep working with it. 

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