you can use conditional formatting on A-D to highlight colors for HIGH & LOW - choose Conditional Formatting then New Rule, choose format only top bottom ranked values. You will have to make 2 rules here one for top & one for bottom & choose top/bottom 1.