sjo007
New member
- Joined
- Dec 1, 2015
- Messages
- 28
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel for Mac 16.4
I have a row of values and a Standard Deviation calculation at the end of each row. I have a cell on the same sheet with an SD number in.
I wish to colour the cell in the row which has the highest and lowest number in IF the SD of that row is below the value of the cell with the SD number in.
I have tried varies formulas with conditional formatting and have not managed this yet.
Any help gratefully received. Using MAC Office Excel Ver 16.4. Huge thanks.
Best wishes,
Stephen
I wish to colour the cell in the row which has the highest and lowest number in IF the SD of that row is below the value of the cell with the SD number in.
I have tried varies formulas with conditional formatting and have not managed this yet.
Any help gratefully received. Using MAC Office Excel Ver 16.4. Huge thanks.
Best wishes,
Stephen