On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faure<jbf.fa...@laposte.net>:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to apply. Ideally i would like six and any suggestions
would be gratefully appreciated.
You can use formula with nested IF() and STYLE() functions.
JBF
Absolutely.
And if you want different formats for different text strings, such as
names if people or something, you can create a style with the same
name for each person and just add the style directly… For example:
=Sheet1.A1 + STYLE(A1)
Except that if Sheet1.A1 is empty, 0 will be displayed rather than an
empty cell.
The following might work:
=IF(Sheet1.A1="";"";STYLE(A1))
But I don't know if this is doable in Andy’s situation.
Regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Thanks to you both for your prompt replies (which actually solve another
problem I was working on!)
In this case, however, it doesn't seem to do what I want (which I didn't
explain in my original query).
What I have is a table with parts listed vertically and dates
horizontally. Each part can be in 1 of 6 different states on any given
day. What I'm trying to do is to set up a sheet whereby if you put, for
example, A in a cell the backgound is red, B is blue, C is green, D is
yellow and so on.
... actually, as I've been typing this, I've worked out that this could
be done using your proposal by having a data entry sheet and a separate
sheet for display and nested IFs, but is there a way of doing this
without the intermediate sheet?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org