The lowest and highest value simultaneously formatted

If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest value, we can successively use the two options by accessing the menu Home – Conditional Formatting – Top/Bottom Rules.

If we have to use these options several times, a macro applicable to each such selection can be recommended.

Author: Ovidiu.S

I am quite passionate about this professional area as if I know something - no matter how little - I want to share it with others.

Leave a Reply