OK then. I'm going in circles on this.

I want to conditionally format the cell that contains the Median or closest
thereto.

I have a row of cells in different currencies eg

a b c d e f
1 USD GBP EUR CHF ZAR AUD
2 10000 13500 17000 8500 12500 4500 Base Currency
3 1 1.54 1.27 .84 .1 .66
Conversion rate to USD
4 10000 20847 21613 7175 1232 2956 Converted to USD

=median(a4:f4) results in 8587 which does not appear in row 4

In another method which uses multiple rows, I subtract the median from the
actual value and square the result to remove any negatives. Then the min of
that is closest to the median and therefore the answer.

But I want to do this in one cell as a conditional format behind A4 to F4.

Any help deeply appreciated!!

Best regards,
Bony




I want to normalise these to a single currency (USD) so as to determine the
Median