Change cell color based on previous cell value (Increase/decrease)

[jayden13]

Hello,

I am looking for support to change a cell color based on whether or not it is an increase or decrease from the previous value.

For example if A1 is "1" and I manually changed it to "2", A1 fill color would change to green (increase) and if A1 was manually changed to 0, the color would change to red (decrease).

Thank you!

[etaf]

use a conditional format
you could either select the range A1

then use a formula

=A1>A2
format colour RED

then a new rule for green
A1<A2

But what colour for =

i'll edit and post a sample

[jayden13]

Hi Wayne,

Thank you for your reply. I am looking to change the value of A1 based on its previous value, rather than a different cell. I have not been able to identify a way to conditionally format a cell based on the same cell's previous values. I want the color of the cell to change based on an increase/decrease in value within the same cell rather than the value itself or any other cell value, if that makes sense?

[etaf]

sorry misunderstood m probably need vba to do that , not my expertise

[way2020]

This method would require you adding a new column. Pass/Fail

In this new column put the following formula for every row to be checked.
IF(A2>1,"Fail","Pass") My example starts at A2 you want the first cell of your
data.

Click on "Conditional Formatting" and then "Highlight Cell Rules" and then
"Text That Contains". A box will appear with The title "Highlight Cell Rules"

First Selection Type Pass and change the drop down entry to "Green Fill with Dark
Green Text" and then OK. Copy A2 and paste down the Pass/Fail Column.

Then repeat the above changing "Pass" to "Fail" and select "Light red with dark
red text" and then "OK" Copy A2 and paste down the Pass/Fail Column.

I am attaching a file with some sample data.

[way2020]

OK it can be done, but you must enter the formulas in A1 and when all formulas have been entered
highlight A1 and use the "Fill Handle" to format the remaining cells.

Look at the attached files "Conditional Formatting Rules.png" and
"Change color.xlsx

Any Value that you do not want colored just change the rule for that value.
Use the PNG file to see how each value 0 through 3 will be formatted

Select Conditional Formatting
Select Highlight Cell Rules
Select Equal To
Dialog Box appears with Equal To title
first enter "0" next enter ""Green Fill with Dark Green Text" next "OK" or select "Custom Format"
Then select font and fill to your choosing" next "OK" and then "OK" again

With mouse in A1
Select Conditional Formatting
Select Highlight Cell Rules
Select Equal To
Dialog Box appears with Equal To title
first enter "1" next enter ""Green Fill with Dark Green Text" next "OK"

With mouse in A1
Select Conditional Formatting
Select Highlight Cell Rules
Select Equal To
Dialog Box appears with Equal To title
first enter "2" next enter ""Green Fill with Dark Green Text" next "OK" or select "Custom Format"
Then select font and fill to your choosing" next "OK" and then "OK" again

With mouse in A1
Select Conditional Formatting
Select Highlight Cell Rules
Select Equal To
Dialog Box appears with Equal To title
first enter "3" next enter ""Light red with dark red text" next "OK"

I am attaching a file with some sample data.