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
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.
Use this:
=AND(ABS(D3-D2)>3,ROW()<>1)
Answered by FlexYourData on December 31, 2020
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP