Writing formula for excel worksheet
 

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)

Writing formula for excel worksheet
 

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
"Gaurav" wrote:

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)

Writing formula for excel worksheet
 

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


"Gaurav" wrote:

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)

Writing formula for excel worksheet
 

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gaurav" wrote:
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)

Writing formula for excel worksheet
 

This will work for 2 columns only if i am having n no of columns than how to
do that?

"Max" wrote:

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gaurav" wrote:
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)

Writing formula for excel worksheet
 

"Gaurav" wrote:
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---