Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Color to a number
I am trying to assign a color to a row depending on the number placed in the
first columb. For example when cell A1 = 4, I want the computer to make cells A1-D1 to be light blue in color. When the "4" changes to "5" the color needs to change to green. Is this possible and how. -- Thank you for your help. KB489 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Color to a number
hi
yes. read up on conditional formating. what version do you have? regards FSt1 "kb489" wrote: I am trying to assign a color to a row depending on the number placed in the first columb. For example when cell A1 = 4, I want the computer to make cells A1-D1 to be light blue in color. When the "4" changes to "5" the color needs to change to green. Is this possible and how. -- Thank you for your help. KB489 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Color to a number
Highlight the cells whose colour you want to change then use conditional
formatting to enter a formula and a 'reaction'. "kb489" wrote: I am trying to assign a color to a row depending on the number placed in the first columb. For example when cell A1 = 4, I want the computer to make cells A1-D1 to be light blue in color. When the "4" changes to "5" the color needs to change to green. Is this possible and how. -- Thank you for your help. KB489 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Color to a number
1. make a table with your conditions i.e. let A1 = 4 and B1 = green.
2. highlight cells where you want color to change 3. format tab conditional formatting change settings to what you want << click ok "kb489" wrote: I am trying to assign a color to a row depending on the number placed in the first columb. For example when cell A1 = 4, I want the computer to make cells A1-D1 to be light blue in color. When the "4" changes to "5" the color needs to change to green. Is this possible and how. -- Thank you for your help. KB489 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a number value to text | Excel Worksheet Functions | |||
Assigning a number to a name | Excel Discussion (Misc queries) | |||
Assigning words to a number | Excel Discussion (Misc queries) | |||
Assigning Color in If Function | Excel Worksheet Functions | |||
Help assigning a number to a word | Excel Discussion (Misc queries) |