Charlie
Reputation: 21
Conditional Formatting based on previous cell value
I'm looking to apply Conditional Formatting to a range of data I have in Excel that will display red if the most recent day of data is below what it was before, and green if it was higher.
Eg Day,Value, Highlight cell colour
- Day 1 1000
- Day 2 2000 Green - as it's higher than day 1
- Day 3 500 Red - as it's lower than day 2
- Day 4 6000 Green
- Day 5 4000 Red
I want to replicate this for all my data and then ideally be able to count the number of 'runs there are' eg number of red cells together so you can see the number of consecutive days that performance has fallen by.
What formula do I use to achieve both things?
Upvotes: 0
Views: 3853
Answers (1)
Related Questions
- Conditional formatting based on previous cell
- Use Conditional Formatting to format a cell based on the value of the cell before it
- Conditional Formatting based on TWO Adjacent Cell Value
- Conditional formatting based on value of adjacent cell
- Conditional formatting based off the previous X number of cells
- (Excel) Conditional Formatting based on Adjacent Cell Value
- How do I apply conditional formatting to an entire column based on the previous rows value?
- Excel - Cells to change color based on previous cell value
- Conditional Formatting with increasing colors
- Copy format of previous cell in conditional formatting