If certain cells are above the standard deviation, they should be formatted conditionally.
How to achieve this? I’ve seen in the conditional formatting an option “higher than the average”, but that is not quite what I wanted, obviously.
Standard deviation would allow me to have some margin of error for higher and lower values, but marking those which are extremely higher or extremely lower too.
!https://bankfotek.pl/image/2126540.jpeg
EDIT: I found the formula for standard deviation and applied it in conditional formatting as “Cell value more than” STDEVA(F3:F45) but not all cells were marked as expected (see cell with 0,99 1,74 and 1,02 respectively).
EDIT2: I checked the range and the last cell is F10, so that’s not the root of the problem)