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/