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


"Roland Burger" wrote in message
...
: 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
:
:
: "Roland Burger" wrote in message
: ...
: : 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/