Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

if value, then bold? any help?

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Data Access Page for Excel  
Author Message
redmondflyer21

External


Since: Dec 1, 2009
Posts: 2



(Msg. 1) Posted: Tue Dec 01, 2009 2:39 pm
Post subject: if value, then bold? any help?
Archived from groups: microsoft>public>excel (more info?)
I'm working on a spreadsheet to track mileage in a running club for
kids...and I'm trying to figure out if there is a way to make it so
that if their total mileage (E2:E20), then their names (A1:A20) could
be in bold...there's got to be a simple way, can anyone help?

- nate

 >> Stay informed about: if value, then bold? any help? 
Back to top
Login to vote
AdamV

External


Since: Dec 1, 2009
Posts: 1



(Msg. 2) Posted: Tue Dec 01, 2009 7:25 pm
Post subject: Re: if value, then bold? any help?
Archived from groups: per prev. post (more info?)
You can do this with a conditional format applied to the names in column
A, depending on a formula relating to column E.
Unfortunately you don't say what specific condition you are looking for
(although I guess it is mileage > some number), and you don't say what
version of Excel you have, so giving you step by step is harder.

Tell us in more detail what condition should trigger the bold, and what
version you have and we can give you a thorouhg job here.

Adam

redmondflyer21 wrote:
> I'm working on a spreadsheet to track mileage in a running club for
> kids...and I'm trying to figure out if there is a way to make it so
> that if their total mileage (E2:E20), then their names (A1:A20) could
> be in bold...there's got to be a simple way, can anyone help?
>
> - nate

 >> Stay informed about: if value, then bold? any help? 
Back to top
Login to vote
redmondflyer21

External


Since: Dec 1, 2009
Posts: 2



(Msg. 3) Posted: Thu Dec 03, 2009 5:25 am
Post subject: Re: if value, then bold? any help?
Archived from groups: per prev. post (more info?)
On Dec 1, 3:14pm, AdamV wrote:
> You can do this with a conditional format applied to the names in column
> A, depending on a formula relating to column E.
> Unfortunately you don't say what specific condition you are looking for
> (although I guess it is mileage > some number), and you don't say what
> version of Excel you have, so giving you step by step is harder.
>
> Tell us in more detail what condition should trigger the bold, and what
> version you have and we can give you a thorouhg job here.
>
> Adam
>
> redmondflyer21 wrote:
> > I'm working on a spreadsheet to track mileage in a running club for
> > kids...and I'm trying to figure out if there is a way to make it so
> > that if their total mileage (E2:E20), then their names (A1:A20) could
> > be in bold...there's got to be a simple way, can anyone help?
>
> > - nate

Thanks Adam,

I have Office 2007, and I suppose i should proofread before submitting
so that I don't leave out any huge tidbits of information. Any how,
what I was trying to do, was if their total mileage E2:E20 is greater
than a value, say 20, than their names in column A would be in bold. l
appreciate your help ~ nate
 >> Stay informed about: if value, then bold? any help? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to Bold partial a text in Excel - Hi to everyone. I want to bold certain areas of a text (only part of the text). For example lets say I have the phrase “Mr John Smith is a software engineer and is 42 years old”, where the name and age are taken from cells in the sheet – these ...

INDEX MATCH HELL ooops.. I mean HELP! - I know (or at least I think I do) that I can do this with INDEX MATCH. Here is what I want to do. I want to place this formula in cell C4 of Sheet 1. What I want this formula to do is to match the value of B2 of Sheet 1 with a list that is in Sheet 2...

Notation Bugs - Did anybody notice that Excel handles math notations (symbols) in an incorrect way? Try this: write -2 in cell A1. Write =1-A1^2 in a different cell. Write =-A1^2+1 in another cell. The two expressions are equivalent, shouldn't they? Well, the former..

How to create a single line separated by commas from a mat.. - Hello, I've the following problem. I've a table made of several columns. Each colum represents a characteristic regarding to a subject (e.g. Name, Surname, Home Street, etc...). In the rows I put the different people. I need to export these info to a....

Excel password Recovery - Hi All, i forgot my excel password, can any tell me how to recover the password there is any free tool is avail in web, Regards, Deen
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]