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 - 30 Sep 2006 17:31 GMT
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
> I'm trying to do something that seems like it should be simple.
>
[quoted text clipped - 14 lines]
> Any suggestions?
> Thanks.