| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating excel
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 Bent Lauridsen wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating excel
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 "Dave Peterson" skrev i en meddelelse ... 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 Bent Lauridsen wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating excel
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! Bent Lauridsen wrote: 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 "Dave Peterson" skrev i en meddelelse ... 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 Bent Lauridsen wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating excel
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". Dave Peterson wrote: 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! Bent Lauridsen wrote: 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 "Dave Peterson" skrev i en meddelelse ... 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 Bent Lauridsen wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formating excel
Hi Dave
Thx for the answer "Dave Peterson" skrev i en meddelelse ... 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". Dave Peterson wrote: 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! Bent Lauridsen wrote: 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 "Dave Peterson" skrev i en meddelelse ... 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 Bent Lauridsen wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formating | New Users to Excel | |||
| Excel Formating | Excel Discussion (Misc queries) | |||
| excel formating | Excel Worksheet Functions | |||
| Excel 2003 - How to delete Custom Formating when Excel sheet is Lo | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Hybrid Mode
