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

Conditional Formating

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Need help in generating a report.  
Author Message
Robert G. Flade, RN, MS

External


Since: Nov 26, 2008
Posts: 2



(Msg. 1) Posted: Wed Nov 26, 2008 6:13 am
Post subject: Conditional Formating
Archived from groups: microsoft>public>excel (more info?)
I have an Excel spreadsheet that has C3=4, C4=3, & C5=2 and I want to do
contitional formating for another cell to have an arrow showing a direction
based on C3 - C5 (e.g., if B3>C3 arrow up, if B3=C4 nothing, if B3<C5 arrow
down). Is there any way to do that? I can make a color of the cell but
would like to have a symbol.

Any help would be appreciated.
Thanks
Bob

 >> Stay informed about: Conditional Formating 
Back to top
Login to vote
google

External


Since: Nov 26, 2008
Posts: 5



(Msg. 2) Posted: Wed Nov 26, 2008 6:40 am
Post subject: Re: Conditional Formating
Archived from groups: per prev. post (more info?)
so "the other cell" would be

=if(B3>C3,"",if(B3<C3,"á","â"))

and formatted as Format->Cells->Font->WingDings.

 >> Stay informed about: Conditional Formating 
Back to top
Login to vote
google

External


Since: Nov 26, 2008
Posts: 5



(Msg. 3) Posted: Wed Nov 26, 2008 6:43 am
Post subject: Re: Conditional Formating
Archived from groups: per prev. post (more info?)
Sorry... that should have been:

=if(B3>C3,"á",if(B3<C3,"â",""))
 >> Stay informed about: Conditional Formating 
Back to top
Login to vote
Robert G. Flade, RN, MS

External


Since: Nov 26, 2008
Posts: 2



(Msg. 4) Posted: Wed Nov 26, 2008 7:01 am
Post subject: Re: Conditional Formating
Archived from groups: per prev. post (more info?)
Thank you. . . that was soooo stupid of me. . . I should have known that. . .
I don't know why I was stuck on thinking "conditional formating" and not an
"if statement". . . duh. . . oh well. . . THANKS again.
Bob
 >> Stay informed about: Conditional Formating 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Conditional formatting - I want to change font when a cell takes a certain value from a formula, but in the conditional formatting box the font selection is ghosted out. Any tips on how I can do this?

Conditional formatting - I seem to have problems writing formulas for conditional formatting. H J K 5 98 103 I want to write a rule such that if K117 is greater than j117 and also if H 117>0, then the cell turns yellow or whatever. Can't get it to work. Thanks

copy conditional formats - I have a column that has been conditionally formatted with equations, using the "fill" command to color the cells based on the relative values of cells in other columns. I want to copy only the colors to another column, but not the equatio...

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..
   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 ]