| View previous topic :: View next topic |
| Author |
Message |
maybe :-D
Guest
|
 Posted: Sun Nov 02, 2003 11:15 am Post subject: automatically background colorchange with an =IF ... |
 |
|
Hi.
I Would like to define the backgroundcolor of a cell by it's value.
For exemple:
1 --> green
2 -- > yellow
3 --> red
I have got a few hunded values, and I would like to make them more visible.
Has anyone an idea?  |
|
| Back to top |
|
 |
tony.groves
OOo Enthusiast
Joined: 24 Aug 2003
Posts: 117
Location: Ireland
|
| Posted: Sun Nov 02, 2003 11:42 am Post subject: |
|
|
| First, define a cell style for each cell format you want to use, then use Conditional Formatting to assign styles depending on the cell contents. |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Sun Nov 02, 2003 11:10 pm Post subject: |
|
|
| Quote: | | few hunded values, and I would like to make them more visible. |
conditional formatting and custom formatting only allow 3 styles to be conditionally applied anything more than that and you will need a macro to paint your colourscheme |
|
| Back to top |
|
|
maybe :-D
Guest
|
| Posted: Mon Nov 03, 2003 10:24 am Post subject: |
|
|
Thx @ tony.groves & dfrench.
I'll try  |
|
| Back to top |
|
|
|
