Conditional formatting a cell based on change

Closed

Anna - Jun 15, 2011 at 12:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2011 at 05:09 PM

Hello,
In Excel, I have columns of values, all are in the same units. Each column represents a new week. If the value in column C4 is increased or decrease by a value of 5 in comparison to the previous week (example, B4), I would like it highlighted. I realize I might have to write 2 separate rules for this, but don't know the correct formula. Does anyone know how to write this formula?

Thanks,
Anna

Conditional formatting a cell based on change
Change computer name cmd - Guide
If cell contains text then return value multiple conditions ✓ - Excel Forum
How to change whatsapp time format - Guide
T-mobile change number - Guide
Idm language change - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 15, 2011 at 01:08 PM

Try this

=ABS(C4-D4)=5

Anna
Jun 15, 2011 at 04:43 PM

Thanks rizvisa1! I tweaked it a little, but that was basically it.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 15, 2011 at 05:09 PM

you are welcome. Cheers

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

How do I change a base location on Instagram?

help me to add particular cells

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!