Home |
Search |
Today's Posts |
#1
|
|||
|
|||
coloured marking
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/ |
#2
|
|||
|
|||
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 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? |
#3
|
|||
|
|||
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/ |
#4
|
|||
|
|||
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 "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/ |
#5
|
|||
|
|||
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/ |
#6
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting coloured cells | Excel Worksheet Functions | |||
Coloured cells based on formula | Excel Worksheet Functions | |||
data sort by highlighted or coloured cell | Excel Worksheet Functions | |||
How do I put a background in a coloured spreadsheet? | Excel Worksheet Functions | |||
Speed of marking cells | Excel Worksheet Functions |