See attached workbook. I have a set of conditional formatting rules applied to ROW 2. The rule is evaluating that single row and highlighting any values that are above or below 3 STDEV from the AVG. I would like to apply that same set of rules to the remaining rows such that each row is evaluated independently. For example; ROW 1 is evaluated as its own range and highlighted as such, ROW 2 is evaluated as its own range and highlighted as such, etc. Is there a way to do this efficiently?
The only way I can figure out to do it is by selecting the currently formatted row, clicking FORMAT PAINT and then individually painting the format row by row down the sheet. When selecting the formatted row and trying to paint the formatting across the entire range at one time, the rows are not evaluated independently, but instead as a single dataset ... not what I need.
Regarding my intent; each row in the sheet represents the monthly sales of a client and my intent is to quikcly and visually identify any outlier months for a given client.
Bookmarks