Forum Discussion
Justin Lee
May 22, 2018Copper Contributor
Formatting Outliers Across Different Units (time, percent, etc.)
Hello, I am looking to format a spreadsheet so that any outliers are highlighted. These don't necessarily need to be mathematical outliers, I'd be fine doing something like "1.5x above or below a...
JKPieterse
May 23, 2018Silver Contributor
You can use conditional formatting to highlight anything above or below 1.5 times the standard deviation.