Problem with conditional formatting

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
 
R

Ragdyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top