coloured marking

R

Roland Burger

Hi,

I'm new in this group and hope this is the right group for my question!

I have an Excel table for my diabetic values! Now I would like to see
these values coloured if they pass over specified values, for example from
150-199 green colour and for more than 200 red colour. Is this possible?

--
Viele Gruesse / Best regards / Serdeczne pozdrowienia
Roland
Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
Poland / Polska
PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
 
T

Tim Otero

Roland,

yes it is. You can do this with conditional formatting. Select the
cell(s) in which you wish the formatting to appear, then click Format |
Conditional Formatting. You can put up to three conditions, each with
different formatting. For the Green, Select cell value is between 150
and 200. For Red select cell value is greater than 200.

HTH

tim
 
R

Roland Burger

Tim Otero wrote on 13.04.2005 09:42 among others:
Roland,

yes it is. You can do this with conditional formatting. Select the
cell(s) in which you wish the formatting to appear, then click Format |
Conditional Formatting. You can put up to three conditions, each with
different formatting. For the Green, Select cell value is between 150
and 200. For Red select cell value is greater than 200.
Click to expand...

Thank you for trying to help me! Unfortunately it's not working with me as
it should. Only some values are green and not all, which should be. No
value is red though I have such, which should be.

I don't know what I have done wrong. It's a table with 4 columns because I
have to measure it 4 times per day! I have set the following:

Condition 1: Cell value is between 150 and 199 - Format: green
Condition 2: Cell value is between 200 and 999 - Format: red
HTH

tim
Click to expand...


--
Viele Gruesse / Best regards / Serdeczne pozdrowienia
Roland
Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
Poland / Polska
PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
 
L

Lady Layla

Are you sure you are entering all the blood sugar values as numbers and not as
text?
Select a cell to the side of the area where you are entering
Enter 1
Copy this cell
Select the area where you are entering the values
Edit - Paste Special - Multiply
Okay

See if this helps the formatting to work


: Tim Otero wrote on 13.04.2005 09:42 among others:
: > Roland,
: >
: > yes it is. You can do this with conditional formatting. Select the
: > cell(s) in which you wish the formatting to appear, then click Format |
: > Conditional Formatting. You can put up to three conditions, each with
: > different formatting. For the Green, Select cell value is between 150
: > and 200. For Red select cell value is greater than 200.
:
: Thank you for trying to help me! Unfortunately it's not working with me as
: it should. Only some values are green and not all, which should be. No
: value is red though I have such, which should be.
:
: I don't know what I have done wrong. It's a table with 4 columns because I
: have to measure it 4 times per day! I have set the following:
:
: Condition 1: Cell value is between 150 and 199 - Format: green
: Condition 2: Cell value is between 200 and 999 - Format: red
: >
: > HTH
: >
: > tim
: >
: > Roland Burger wrote:
: >
: >> Hi,
: >>
: >> I'm new in this group and hope this is the right group for my question!
: >>
: >> I have an Excel table for my diabetic values! Now I would like to see
: >> these values coloured if they pass over specified values, for example
: >> from
: >> 150-199 green colour and for more than 200 red colour. Is this possible?
: >>
:
:
: --
: Viele Gruesse / Best regards / Serdeczne pozdrowienia
: Roland
: Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
: Poland / Polska
: PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
: Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
 
R

Roland Burger

Lady Layla wrote on 13.04.2005 16:05 among others:
Are you sure you are entering all the blood sugar values as numbers and not as
text?
Click to expand...

All is formated as numbers!!!
Select a cell to the side of the area where you are entering
Enter 1
Copy this cell
Select the area where you are entering the values
Edit - Paste Special - Multiply
Click to expand...

Sorry, I don't understand this. I have German Windows and I don't there
anything likr "Paste Special" and "Multiply"!
Okay

See if this helps the formatting to work


: Tim Otero wrote on 13.04.2005 09:42 among others:
: > Roland,
: >
: > yes it is. You can do this with conditional formatting. Select the
: > cell(s) in which you wish the formatting to appear, then click Format |
: > Conditional Formatting. You can put up to three conditions, each with
: > different formatting. For the Green, Select cell value is between 150
: > and 200. For Red select cell value is greater than 200.
:
: Thank you for trying to help me! Unfortunately it's not working with me as
: it should. Only some values are green and not all, which should be. No
: value is red though I have such, which should be.
:
: I don't know what I have done wrong. It's a table with 4 columns because I
: have to measure it 4 times per day! I have set the following:
:
: Condition 1: Cell value is between 150 and 199 - Format: green
: Condition 2: Cell value is between 200 and 999 - Format: red
: >
: > HTH
: >
: > tim
: >
: > Roland Burger wrote:
: >
: >> Hi,
: >>
: >> I'm new in this group and hope this is the right group for my question!
: >>
: >> I have an Excel table for my diabetic values! Now I would like to see
: >> these values coloured if they pass over specified values, for example
: >> from
: >> 150-199 green colour and for more than 200 red colour. Is this possible?
: >>
:
:
: --
: Viele Gruesse / Best regards / Serdeczne pozdrowienia
: Roland
: Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
: Poland / Polska
: PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
: Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
Click to expand...


--
Viele Gruesse / Best regards / Serdeczne pozdrowienia
Roland
Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
Poland / Polska
PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
 
L

Lady Layla

All can be formatted as numbers but yet still entered as text in error
Can't help with the German version but with Excel


: Lady Layla wrote on 13.04.2005 16:05 among others:
: > Are you sure you are entering all the blood sugar values as numbers and not
as
: > text?
:
: All is formated as numbers!!!
:
: > Select a cell to the side of the area where you are entering
: > Enter 1
: > Copy this cell
: > Select the area where you are entering the values
: > Edit - Paste Special - Multiply
:
: Sorry, I don't understand this. I have German Windows and I don't there
: anything likr "Paste Special" and "Multiply"!
:
: > Okay
: >
: > See if this helps the formatting to work
: >
: >
: > : > : Tim Otero wrote on 13.04.2005 09:42 among others:
: > : > Roland,
: > : >
: > : > yes it is. You can do this with conditional formatting. Select the
: > : > cell(s) in which you wish the formatting to appear, then click Format |
: > : > Conditional Formatting. You can put up to three conditions, each with
: > : > different formatting. For the Green, Select cell value is between 150
: > : > and 200. For Red select cell value is greater than 200.
: > :
: > : Thank you for trying to help me! Unfortunately it's not working with me as
: > : it should. Only some values are green and not all, which should be. No
: > : value is red though I have such, which should be.
: > :
: > : I don't know what I have done wrong. It's a table with 4 columns because I
: > : have to measure it 4 times per day! I have set the following:
: > :
: > : Condition 1: Cell value is between 150 and 199 - Format: green
: > : Condition 2: Cell value is between 200 and 999 - Format: red
: > : >
: > : > HTH
: > : >
: > : > tim
: > : >
: > : > Roland Burger wrote:
: > : >
: > : >> Hi,
: > : >>
: > : >> I'm new in this group and hope this is the right group for my question!
: > : >>
: > : >> I have an Excel table for my diabetic values! Now I would like to see
: > : >> these values coloured if they pass over specified values, for example
: > : >> from
: > : >> 150-199 green colour and for more than 200 red colour. Is this
possible?
: > : >>
: > :
: > :
: > : --
: > : Viele Gruesse / Best regards / Serdeczne pozdrowienia
: > : Roland
: > : Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
: > : Poland / Polska
: > : PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
: > : Skype: roland1713 - low-priced calling over computer -
http://www.skype.com/
: >
: >
:
:
: --
: Viele Gruesse / Best regards / Serdeczne pozdrowienia
: Roland
: Thawte Web of Trust notary und/and/i CAcert assurer, Zywiec, Polen /
: Poland / Polska
: PGP-Key: http://www.biglumber.com/x/web?qs=0x2187626E
: Skype: roland1713 - low-priced calling over computer - http://www.skype.com/
 
Top