Conditional Formatting (Formula)
 

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

Conditional Formatting (Formula)
 

CF formula of

=COUNTA(C1:C9)=0

--
---
HTH

Bob


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



"mpenkala" wrote in message
...
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

Conditional Formatting (Formula)
 

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Conditional Formatting (Formula)
 

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" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Conditional Formatting (Formula)
 

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Conditional Formatting (Formula)
 

Thanks T. Valko,

Works great!

Matt

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Conditional Formatting (Formula)
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
Thanks T. Valko,

Works great!

Matt

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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