Conditional Formatting...

[sumospim]

Hi all, i wonder if someone could help me on the above?

I want to automatically place a colour in a cell for the following instances.

1. When a cell is between a certain range ( +/- 7.5% of a value) (CORE range)
2. When a cell is between +7.5% and 15% of a value (HIGH range)
3. When a cell is between -7.5% and -15% of a value (LOW range)
4. When a cell is > than 15% of a value (SUPERHIGH range)
5. When a cell is < than 15% of a value. (SUPERLOW range)

Any guidance would be greatly appreciated.

Best wishes

Simon

 

[sumospim]

Many, many thanks!!

 

[alvin-chung]

You're welcome