Cond format a range - minimum value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi agai

I have 10 columns of data, what I would like to do is have the value of the smallest number in RED

A B C D E F G H I
12 10 6 5 9 13 2 6 7 1
43 35 46 43 34 44 46 38 54 5

So in Row 1 "G1" would be in red (cell of character is ok
in Row 2 "E2

Any idea, cos I haven't !

Geron
 
Hi Geron
I am sure there is a simpler way than this, but this works.

In Cell K1 put =SMALL(range,1)
this will give you the minimum number in that row.
Now highlight the range of cells (except K1) and use
Conditional Formatting to create a Cell value equals K1
and set the formats to red.

Regards
Michael
-----Original Message-----
Hi again

I have 10 columns of data, what I would like to do is
Click to expand...
have the value of the smallest number in RED.
A B C
Click to expand...
D E F
G H I J
12 10 6
Click to expand...
5 9 13
2 6 7 10
43 35 46
Click to expand...
43 34 44
46 38 54 54
 
Hi
try the following:
- select you data range (e.g. A1:J20)
- goto 'Format - Conditional Format'
- enter the following formula
=A1=MIN($A1:$J1)
- choose a format
-----Original Message-----
Hi again

I have 10 columns of data, what I would like to do is
Click to expand...
have the value of the smallest number in RED.
A B C
Click to expand...
D E F
G H I J
12 10 6
Click to expand...
5 9 13
2 6 7 10
43 35 46
Click to expand...
43 34 44
46 38 54 54
 
Back
Top