1 min readfrom 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.

submitted by /u/ABAAug
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com