Conditional formatting - compound condition

E

Eric

I'm trying to do something that seems like it should be simple.

In Cell A10, I want conditional formatting that says: if Cell A10 is not
blank AND Cell C5 = 1, then apply conditional formatting.

I can use the Cell Value Is for the A10 check (applying one format), and the
Formula Is option for the C5 check (applying another format). But I can't
combine them so that I do the two checks and if they're BOTH true, apply a
formula.

If I try to use the Formula Is option with a cell that references both
cells, I get a circular reference, which Excel doesn't like. (I.e., Cell A10
with conditional formatting using a formula which references A10 itself.)

Any suggestions?
Thanks.
 
T

Trevor Shuttleworth

Conditional formatting

Formula is: =AND($A$10<>"",$C$5=1) apply format

If you need this in other cells you may need to move the absolute references

Regards

Trevor
 

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