ExcelBanter - Formating excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formating excel (https://www.excelbanter.com/excel-programming/351132-formating-excel.html)

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

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

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

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

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

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