Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis skills today ...

TL:dr; How do I format cells with a color based upon absolute value without changing the actual values in the cells to absolute values?