Problem with conditional formatting
 

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

Problem with conditional formatting
 

CF *stops* at the *first* TRUE condition.

SO, make condition 1:

=AND($A7<"",$C7="Cash Withdrawal")
And format to orange with borders.

Condition 2:

=$A7<""
And format to just borders.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"WLMPilot" wrote in message
...
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