 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006Formating excel
Hi All is there anyone that can help me with a little problem. I would like to hear, if there is anyone of you that can tell me if it is possible to get excel to make frames in a cell depending of the contens. ex. if I in a cell have a SUM() function that result in a value >10000 then there should be a frame in the top of the cell, and if it is >15000 then both a frame in top and one in the bottom of the cell. Yours Bent Lauridsen / Bamsefar If frames mean borders, it sounds like: Format|conditional formatting may do what you want. Debra Dalgleish has some notes at: http://contextures.com/xlCondFormat01.html > Hi All > [quoted text clipped - 11 lines] > > Bent Lauridsen / Bamsefar  SignatureDave Peterson Hi Dave Yes it is borders I mean. but when I in the cell have a if(x<y;z;f) I would like in the condition true have one type borders, and if it is false another type borders, is that possible ??? Yours Bent Laurdisen / Bamsefar > If frames mean borders, it sounds like: > Format|conditional formatting may do what you want. [quoted text clipped - 17 lines] >> >> Bent Lauridsen / Bamsefar Format|Conditional formatting works with the value in the cell--not the formula. And you can specify up to 3 different conditional formats for that cell (plus the "normal" one). If z and f represent values, you can use: Cell value is equal to 15 (format it one way) Add another condition Cell value is equal to -88.3 (format it another way) == Or you could use: Formula is: x<y (apply one format) formula is: x>=y (apply the other format) === Debra's site does a nicer job of explaing this stuff--and it has pictures! > Hi Dave > [quoted text clipped - 33 lines] > > > > Dave Peterson SignatureDave Peterson Format|Conditional formatting works with the value in the cell--not the formula. should have been: One way to work with conditional formatting is to use the value in the cell. You can use almost any old formula if you choose "Formula is". > Format|Conditional formatting works with the value in the cell--not the formula. > [quoted text clipped - 63 lines] > > Dave Peterson SignatureDave Peterson Hi Dave Thx for the answer > Format|Conditional formatting works with the value in the cell--not the > formula. [quoted text clipped - 80 lines] >> >> Dave Peterson |
Reply to this Message |
 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.