Skip to Content
avatar image
Former Member

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!!

11am 12pm 11am 12pm Region1 5 6 7 8 Region2 4 12 13 14 Region2 7 8 9 10 Region4 4 5 6 7 Region5 12 13 14 15 Region6 5 6 7 8
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 05, 2015 at 05:22 AM

    Hi Akshay,

    If std deviation of each region is different I would suggest to take each region in one table and apply conditional formatting in each table based on different condition.

    To give it a single table view please use relative positioning.(Works well only if Region are constant)

    Its jus workaround

    Regards

    Sheetal.

    Add comment
    10|10000 characters needed characters exceeded