Help in Conditional Formatting Formula

[AthmanArumugam]

Hi,

In the attached xl, I have seven columns with each column having 89 values.
I need to highlight those rows in range A2:G89 where the value in column "123" is less than the values in all the other six columns. I have come up with the below coonditional formatting formula , but still it doesn't work. Could you all kindly guide here

{=SUMPRODUCT(--(A2:A89<B2:B89)*--(A2:A89<C2:C89)*--(A2:A89<D2:D89)*--(A2:A89<E2:E89)*--(A2:A89<F2:F89)*--(A2:A89<G2:G89)*(A2:A89))>0}

 

[Peter Bartholomew]

Hello

I had a number of problems with this. The first was that the conditional format showed up as a text string and not a formula. The next issue was that there were no instances in which column 123 data was smaller than all others.

That aside, my formula for conditional formatting was
= MIN(Table1[@])=Table1[@123]

Because the conditional format dialogue box is not exactly a supportive environment for developing formulas, I first wrote candidate formulas on the worksheet and then took the best and turned it into a defined name 'highlight' using Name Manager. The conditional format formula is then
= highlight

If this is not the effect you wanted then by all means explain you requirement in further detail.

 

[salim hasan]

try this file

 

[pecoflyer]

There is no need to add braces in CF. By default every formula you enter for CF is considered to be an array formula

 

[AthmanArumugam]

Thanks Peter and Salim. Both your solutions worked for me.