Conditional formatting - compound condition Eric 30.09.2006 15:47:01 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.

Re: Conditional formatting - compound condition "Trevor Shuttleworth" <Trevor[ at ]Shucks.demon.co.uk> 30.09.2006 16:31:24 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 "Eric" <Eric[ at ]discussions.microsoft.com> wrote in message news:8A9D11AB-1B5F-4608-9BC5-05E9CE1B964A[ at ]microsoft.com... [Quoted Text] > 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.