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]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#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