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
Change lg tv name - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
How to change date format in excel - Guide
How to change number of best friends on snapchat - 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

Highlight cell if another cell contains specific text

help me to add particular cells

How to use conditional format based on text?

Excel function question

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!