Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Std Devation - Conditional Formating

Hello All,

I have been trying to do some conditional formatting,

I want to highlight/mark red all those numbers above 1 std deviation of the mean.

Following is just an example. That is structure of my data and i want to color the data red as soon in the table. What formula would i use to get something like that. Std Dev for each 'Region' is different. So i will have a average and Std. Dev for each region.

Can some one please help me which this.

Thank you!!

11am12pm11am12pm
Region15678
Region24121314
Region278910
Region44567
Region512131415
Region65678
Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question