Format Conditioning/Rank

  • Thread starter Thread starter Martin Wheeler
  • Start date Start date
M

Martin Wheeler

xl2000
I want to add a format condition to column A
It would place a border around the cell in range a7:a31
The criteria being which corresponding cell in c7:c31 has the lowest value.
The values are all positive numbers to 2 decimal places
I have tried in a7 the following = c7 = rank(c7, c7:c31, 2)
It does not reject it but does not work either.
Any help would be appreciated.
Ta,
Martin
 
Hi Martin,

If I understand you correctly. Use this formula in your
conditional formatting:

=A7=MIN(C7:C31)

If the value in A7 = the lowest value in the range C7:C31
then the border format will be applied.

Biff
 
Martin,

Highlight/select A7:A31 (with A7 as the active cell)

Format|Conditional Formatting

For Condition 1 Select "Formula Is"

=MIN($A$7:$A$31)=A7

Set the formatting options you desire.

Click "OK"

HTH

PC
 
Hi Paul,
I tried your formula and changed the cell ref to
=MIN($C$7:$C$31)=C7 but it does not want to work.
I changed the cell ref as it is col C that I want to evaluate and have it
show in col A
Any ideas ?
Ta,
Martin
 
Hi Bif,
I tried your formula and but it does not want to work.
I think I have put you wrong. I want to see if the value in C7 is the
lowest in C7:C31 and if so then I want to format A7. I have run out of
format conditions in C7.
Any ideas?
Ta,
Martin
 
Hi Paul,
I just realised that I may have put you wrong. I want to see if the value
in C7 is the lowest in C7:C31 and if so then I want to format A7. I have
run out of format conditions in C7.
 
Back
Top