Item Rate1 Rate2 Rate3
A 3 4 6
B 8 5 23
C 56 5 78
Above is my excel sheet.
I want to write some formula so that in every row cell having minimum rate
should come bold. Like For Item A - Rate1(3)
for Item B - Rate2(5)
For Item C - Rate2 (5)
Mike - 22 Feb 2007 10:24 GMT
There may be a neater way but this works. Somewhere in you sheet in a cell
type =min(A1:a4), I used L1 Change this to watever range you are trying to
evaluate.
Then select this range and click format - conditional format - cell value -
is equal to
=($L$1) and apply your bold font.
The lowest value in the range will then become bold.
Mike
> Item Rate1 Rate2 Rate3
> A 3 4 6
[quoted text clipped - 6 lines]
> for Item B - Rate2(5)
> For Item C - Rate2 (5)
CmK - 22 Feb 2007 10:35 GMT
hey
Select each row and apply Conditional Formatting
cell value - equal to - =min(1:1) for the first row and then bold
then the 2nd row
cell value - equal to - =min(2:2) for the first row and then bold
Etc
etc
hope this helped
> Item Rate1 Rate2 Rate3
> A 3 4 6
[quoted text clipped - 6 lines]
> for Item B - Rate2(5)
> For Item C - Rate2 (5)
Max - 22 Feb 2007 14:48 GMT
Select all the rows from row2 down (this ensures A2 is active)
Click Format > Conditional Formatting
Under Condition 1, set it as:
Formula is: =AND(ISNUMBER(A2),A2=MIN(2:2))
Click Format button > Font tab > Bold/red? > OK
Click OK at the main dialog

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Item Rate1 Rate2 Rate3
> A 3 4 6
[quoted text clipped - 6 lines]
> for Item B - Rate2(5)
> For Item C - Rate2 (5)
Gaurav - 23 Feb 2007 06:14 GMT
This will work for 2 columns only if i am having n no of columns than how to
do that?
> Select all the rows from row2 down (this ensures A2 is active)
>
[quoted text clipped - 14 lines]
> > for Item B - Rate2(5)
> > For Item C - Rate2 (5)
Max - 23 Feb 2007 13:06 GMT
> This will work for 2 columns only
> if i am having n no of columns than how to do that?
The initial step given earlier:
> > Select all the rows from row2 down (this ensures A2 is active)
means to select entire rows (select the row headers)
If you did the above step correctly, you'd find that the CF will work across
entire rows, ie across all cols. Give it another try.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---