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.
Any guidance would be greatly appreciated.
Best wishes
Simon
I want to automatically place a colour in a cell for the following instances.
- When a cell is between a certain range ( +/- 7.5% of a value) (CORE range)
- When a cell is between +7.5% and 15% of a value (HIGH range)
- When a cell is between -7.5% and -15% of a value (LOW range)
- When a cell is > than 15% of a value (SUPERHIGH range)
- When a cell is < than 15% of a value. (SUPERLOW range)
Any guidance would be greatly appreciated.
Best wishes
Simon