TransWikia.com

Conditional Formatting: How to change cell colour based on previous cell data

Super User Asked by James McTiernan on December 31, 2020

I am looking for help to create a formula that will highlight a cell if the variance of that cell is greater than 3 from the previous cell.
I have found a formula that will highlight cells less than the previous cell =AND(D5<D16,ROW()<>1).
I wish to modify this so if the current cell has a variance of greater than 3 from previous cell that it will change to red colour.
Any help would be great. Thanks in advance

enter image description here
For example please see screenshot. Whn the data is entered for March it will look at Feb result and see that the variance is greater than 3% and then highlight in red. Similarly for results for Jun, Sep and Dec.
The production yeild cells have formula in them already to calculate the %yield in case this makes a difference.
enter image description here

One Answer

Use this:

=AND(ABS(D3-D2)>3,ROW()<>1)

Answered by FlexYourData on December 31, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP