| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic cell color change when filled?
Can I do this? I want the colour of a cell to change when something is
entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell color change when filled?
One way would be to set Conditional Formatting on the cells you wish to
control, using Format ConditionalFormatting CellValueIs GreaterThan 0, and for conditon 2, CellValueIs LessThan 0...........you could use the same, or different backround colors for the negative numbers.......... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Can I do this? I want the colour of a cell to change when something is entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell color change when filled?
Oh yes... thanks, that works brilliantly
-- Thanks Michele "CLR" wrote: One way would be to set Conditional Formatting on the cells you wish to control, using Format ConditionalFormatting CellValueIs GreaterThan 0, and for conditon 2, CellValueIs LessThan 0...........you could use the same, or different backround colors for the negative numbers.......... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Can I do this? I want the colour of a cell to change when something is entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell color change when filled?
You're welcome..........and thanks for the feedback.......
Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Oh yes... thanks, that works brilliantly -- Thanks Michele "CLR" wrote: One way would be to set Conditional Formatting on the cells you wish to control, using Format ConditionalFormatting CellValueIs GreaterThan 0, and for conditon 2, CellValueIs LessThan 0...........you could use the same, or different backround colors for the negative numbers.......... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Can I do this? I want the colour of a cell to change when something is entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell color change when filled?
how do you do that? i've been trying to figure it out, and i've not been
able to do come up with it. can you give me an example? "CLR" wrote: You're welcome..........and thanks for the feedback....... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Oh yes... thanks, that works brilliantly -- Thanks Michele "CLR" wrote: One way would be to set Conditional Formatting on the cells you wish to control, using Format ConditionalFormatting CellValueIs GreaterThan 0, and for conditon 2, CellValueIs LessThan 0...........you could use the same, or different backround colors for the negative numbers.......... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Can I do this? I want the colour of a cell to change when something is entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell color change when filled?
I sent you a reply to your other post.
It's a link that will show you how. Regards John "confusedguy" wrote in message ... how do you do that? i've been trying to figure it out, and i've not been able to do come up with it. can you give me an example? "CLR" wrote: You're welcome..........and thanks for the feedback....... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Oh yes... thanks, that works brilliantly -- Thanks Michele "CLR" wrote: One way would be to set Conditional Formatting on the cells you wish to control, using Format ConditionalFormatting CellValueIs GreaterThan 0, and for conditon 2, CellValueIs LessThan 0...........you could use the same, or different backround colors for the negative numbers.......... Vaya con Dios, Chuck, CABGx3 "Michele R" wrote: Can I do this? I want the colour of a cell to change when something is entered into it. It could also be the row, either way would do. For example, I have a column which is rarely used, so I need to highlight when it has been used, and I thought an easy and obvious way of doing this might be by adding a colour to the cell. Can anyone help? -- Thanks Michele |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
Linear Mode
