W
WLMPilot
I am setting up a basic check register for someone. I have turned off the
gridlines.
I have set up two conditions that I want something to happen and I cannot
get one of the conditions to kick in.
Entry for transactions begin on row 7. For this question,
Column A = DATE (beginning in A7) and
Column C = Description (beginning in C7)
Condition 1: Formula Is -- =AND($A7<>"")
FORMAT is a thin line border. Since gridlines are off, this is to
create a border
for all columns for the current row (transaction) being entered.
Condition 2: Formula Is -- =AND($C7="Cash Withdrawal")
FORMAT is font of bold orange. This condition is painted across columns
Date, Check Number and Description (Column C).
CONDITION 2 is not working. Any ideas?
Thanks,
Les
gridlines.
I have set up two conditions that I want something to happen and I cannot
get one of the conditions to kick in.
Entry for transactions begin on row 7. For this question,
Column A = DATE (beginning in A7) and
Column C = Description (beginning in C7)
Condition 1: Formula Is -- =AND($A7<>"")
FORMAT is a thin line border. Since gridlines are off, this is to
create a border
for all columns for the current row (transaction) being entered.
Condition 2: Formula Is -- =AND($C7="Cash Withdrawal")
FORMAT is font of bold orange. This condition is painted across columns
Date, Check Number and Description (Column C).
CONDITION 2 is not working. Any ideas?
Thanks,
Les