[EMAIL PROTECTED] schrieb:
Hallo,
Hi,
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.
It is important to check the cursor position inside the selection. You
have to enter the relative addresses in your formula according to this
cursor position. If you select A1:B12 with mouse or keyboard, starting
from A1, the cursor will usually be located in cell B12. So, the address
$A1 entered in cell B12 will result in "column A, 11 rows to top" (row
12 to row 1). This results in an invalid reference in the rows 1 to 11.
To solve your problem: You can move the cell cursor with the TAB key to
cell A1 before you open the dialog, or you can enter the formula using
"$A12" and "$B12" instead of $A1 and $B1, when the cursor is located in B12.
Regards
Daniel
PS: Please consider to use the [EMAIL PROTECTED] mailing list for
questions about Calc, as they may be missed too easily here.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
