Colourcode based on value range

[cocohead]

I need to coulorcode in red all values in a worksheet that are outside a range. The range (for example between 0 and 100) will need to be typed into manually as can vary. For example, in a worksheet I want to have all values smaller than 0 and larger than 1000 in red. In the next worksheet, I want all values smaller than 0 and bigger than 500 in red.

 

[GlennUK]

Cross-posted:

http://www.ozgrid.com/forum/showthread.php?t=155773