AnswerBun.com

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

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

Super User Asked by James McTiernan on December 31, 2020

1 Answers

One Answer

Use this:

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

Answered by FlexYourData on December 31, 2020

Add your own answers!

Related Questions

access to Azure Active Directory

0  Asked on December 19, 2020 by sudhakar-reddy

 

Unable to copy in bluestacks

2  Asked on December 18, 2020 by sagar

         

SSH Multiple Session -> “stdin: is not a tty”

1  Asked on December 18, 2020 by mijago

       

XenServer: Backing up VMs to NAS

0  Asked on December 17, 2020 by grumpy-ol-bear

     

VirtualBox is very slow in Windows 10

11  Asked on December 17, 2020 by ali

     

Sed for windows

2  Asked on December 17, 2020 by thesavo

     

Identify 4-pin power socket

0  Asked on December 16, 2020 by c_b

     

AT commands to activate CDMA modem?

0  Asked on December 16, 2020 by david-pfeffer

     

ssh-keyscan returns different values on each invocation

0  Asked on December 16, 2020 by sweetjonnie

 

less command does not open zip files on debian

2  Asked on December 16, 2020 by m-j

         

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved.