June 9, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

LF Conditional Formatting Help, 3rd Consecutive Cell with a Value within a Range

Is there a conditional formatting formula I can write that will highlight a cell if it's the 3rd consecutive cell that has a value of 80% or higher?

For example, if I have the data

30%

40%

50%

60%

70%

80%

40%

80%

I would want the conditional formatting to highlight the final 80% because it was the third 80% in a row.

Check out the full article on the original site

#Excel alternatives for data analysis

#generative AI for data analysis

#rows.com

#natural language processing for spreadsheets

#AI formula generation techniques

#big data management in spreadsheets

#conversational data analysis

#Excel compatibility

#row zero

#real-time data collaboration

#intelligent data visualization

#data visualization tools

#formula generator

#enterprise data management

#big data performance

#Excel alternatives

#data analysis tools

#data cleaning solutions

#financial modeling with spreadsheets

#conditional formatting