Hallo,
I tried a conditional formatting of a range in calc.
In A1:A12 is always 2007 as text,
in B1:B12 are then months January, February, ... , Decembre.
I want to hightlight the appropriate row by conditional formatting and the
formula: =($A1=YEAR(TODAY()))*(MONTH("1"&$B1)=MONTH(TODAY())).
Therefore I
- mark A1:B12
- call Format - Conditional Formatting
- Condition 1 - "Formula is"
- ($A1=YEAR(TODAY()))*(MONTH("1"&$B1)=MONTH(TODAY()))
- Cell Style is "Heading"
- OK
Nothing happens.
A check of any cell of this range shows, that Calc does not autofill the
formula appropriate for all marked cells, but returned
($A#REF!=YEAR(TODAY()))*(MONTH("1"&$B#REF!)=MONTH(TODAY()))
as an "invalid reference" error.
What did I do wrong?
Must I really do all my conditional formatting cell by cell?
Sincerely
d. wal
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
