CODEWITHSUNDEEP
excelconditional-formatting
RShome
RShome

Reputation: 537

Excel conditional formatting after data refresh

I'm trying to apply conditional formatting to a cell in Excel 2016, to indicate if the value has increased or decreased after a data refresh. I know how to do this using Icon sets etc. if I am comparing a cell value with another cell value, but what if you have no other cell to compare it to?

So lets say I have a value in A1. This value gets updated after refresh. I want to show that the value in A1 has increased or decreased for that one cell.

I hope I am making sense.

Upvotes: 1

Views: 1292

Answers (1)

pnuts
pnuts

Reputation: 59495

One way is to have another cell to relate it to, say B1 containing:

=A1-B1

Then clear any existing CF from A1, select it and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::

=B1<0

Format..., select formatting of choice (I suggest red fill) OK, OK.

Then add another rule:

=B1>0

(I suggest green fill).

Above requires iterative calculation to be turned on (in Options) with Maxium Iterations set to 1.

Upvotes: 1

Related Questions