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%
50%
60%
70%
80%
40%
80%
80%
80%
I would want the conditional formatting to highlight the final 80% because it was the third 80% in a row.
Posted Jun 8, 2026, 4:46 PM UTC
216