•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%
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com