Writing formula for excel worksheet

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

Guest

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)
 
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
 
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
 
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
 
Gaurav said:
This will work for 2 columns only
if i am having n no of columns than how to do that?
Click to expand...

The initial step given earlier: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.

---
 
Back
Top