Conditional Formatting (Formula)

[mpenkala]

Hi,

What I'm looking for is for cell C10 to change color IF the 9 cells above it
are blank.
Any ideas? The cells above it would either be blank or "x".

Thanks!
Matt

 

[Bob Phillips]

CF formula of

=COUNTA(C1:C9)=0

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

Try this:

=COUNTIF(C1:C9,"X")=0

 

[mpenkala]

Thanks Biff,

this one worked. Now how could I add a AND statement to that? Such as:
Color changes if:

=COUNTIF(C1:C9,"x")=0 AND A10 has a number in it (<>"")

Thanks!
Matt

 

[T. Valko]

Try this:

=AND(COUNTIF(C1:C9,"x")=0,COUNT(C10))

 

[mpenkala]

Thanks T. Valko,

Works great!

Matt

Try this:

=AND(COUNTIF(C1:C9,"x")=0,COUNT(C10))

 

[T. Valko]

You're welcome. Thanks for the feedback!