Hello,

I have a spreadsheet with data that is being populated on a daily basis and need to know if there is a way that I can highlight any cells that fall outside of a certain range. For example:

23, 22, 24, 21, 24, 50, 20... etc etc

where the absolute difference between any of the values is +/- 25

So in the example cells above I would need to have the 6th cell (=50) highlighted in red.

Is there an excel formula available that can do this?
I've self taught myself and am having trouble doing this so I'd be grateful for any tips...

Kind regards,

Keith