Using OOo 1.1.4 Calc, there are three (3) conditions one can set for
Conditional Formatting of cells.
I am building a spreadsheet as a darts score sheet, and it is performing
very well indeed, calculating the highest peg, highest score, players
averages, etc.
I am using conditional formatting to highlight:
1. scores >100
2. scores equal to the highest score (more than one player can score this
number)
3. scores equal to the highest peg (more than one player can score this
number)
Each of these is distinguished by a different background colour and cell
border colour.
QUESTION
What happens if more than one condition is true?
eg. if one particular cell contains the score 141
if 141 was the highest score then the background would be Red
if 141 was the highest peg then the background would be Yellow
if 141 is > 100 then the background would be Blue/Grey
How does Calc deal with the situation where 141 is all of these things? ...
ie the highest score, highest peg, and, of course, it is >100
I have tried to work it out but there does not seem to be a consistent
pattern to the results of my experiments.
Many thanks, James Elliott
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
