How, when entering a value in an Excel table, compare it with the previous one?

I

Igor Mamontov2021-03-04 13:07:14

excel

Igor Mamontov, 2021-03-04 13:07:14

I have a table with data that is updated once a month by overwriting new values in a cell. Is it possible to automatically highlight rising or falling values as you type?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2021-03-04
@ForestAndGarden

Store two sets of data: for the new month and the old month.
Highlight with conditional formatting.