Conditional formatting - compound condition

[Guest]

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.

 

[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