Excel formula help

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?





Hi @H_Jones1985 ,


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


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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
W10-1903 UNC path failing 0x80070043
kurgan in Windows Insider Program on
80 Replies