Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

Writing formula for excel worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gaurav - 22 Feb 2007 09:20 GMT
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
---

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.