I am trying to return the lowest value in a range of cells that have been highlighted by conditional formatting out of an even larger range of cells.
For example in a range of cells (E12:DA12), AD12 = 70 and AD13 = 75 and are both coloured red by conditional formatting. As 70 is lower than 75, in a different cell (D12) I want to return the value 70.
The conditional formatting used to highlight the cells red is =MEDIAN(E$2,E$5,$C10)-MEDIAN(E$2,E$5,$B10)>0
I am not sure if it's possible?
Thanks in advance for any advice.
For example in a range of cells (E12:DA12), AD12 = 70 and AD13 = 75 and are both coloured red by conditional formatting. As 70 is lower than 75, in a different cell (D12) I want to return the value 70.
The conditional formatting used to highlight the cells red is =MEDIAN(E$2,E$5,$C10)-MEDIAN(E$2,E$5,$B10)>0
I am not sure if it's possible?
Thanks in advance for any advice.