CODEWITHSUNDEEP
excelexcel-formula
DariusThe1st
DariusThe1st

Reputation: 3

Changing the color of a cell after entering a different value

I'm trying to automate the color changing that should happen after entering a different value in the next bottom cell.

The color should not change if the entered value is the same as the value entered in the cell above it.

The end result should look like this:

enter image description here

Upvotes: 0

Views: 43

Answers (1)

Solar Mike
Solar Mike

Reputation: 8375

So, try this, selected the cells, but made sure that the cell A2 is allowed to move down ie not $A$2 but $A2:

enter image description here

Upvotes: 2

Related Questions