Std Devation - Conditional Formating
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.