•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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
- Setting up Conditional FormattingI'm having trouble working out how to get conditional formatting to work for what I need. So basically I will have 4 separate numbers (shown as a percentile) that could range from 0% - 100%. Now i want each number to change colour based on where it is in regards to 0-100. Now if i select all 4 cells and format them to have red for 0% and green for 100% then the highest number is always green. And the lowest number, even if its say 78%, is red. And if i format each cell independently then they always come out green, regardless of the number. So how do I get each cell to play by my rules? submitted by /u/FearlessResearcher48 [link] [comments]