Conditional Formatting for Dummies

[NumLock]

Another stupid inquiry from me, this time regarding conditional
formatting.

I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank. So I created conditional formatting with two
formulas:

#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]

Clearly this isn't working, but I can't seem to figure out how to
write it so it works. It's shaded if there is any value in any cell,
and still shaded if all the cells have values. I'm sure the answer is
simple but it's just not coming to me. Thanks for the help!

 

[Tyro]

If you're using Excel 2007, put the AND formula first and check Stop if True

Tyro

 

[NumLock]

Sadly, I am using 2003 :-/

If you're using Excel 2007, put the AND formula first and check Stop if True

Tyro

Another stupid inquiry from me, this time regarding conditional
formatting.

I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank.  So I created conditional formatting with two
formulas:

#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]

Clearly this isn't working, but I can't seem to figure out how to
write it so it works.  It's shaded if there is any value in any cell,
and still shaded if all the cells have values.  I'm sure the answer is
simple but it's just not coming to me.  Thanks for the help!- Hide quoted text -

- Show quoted text -

 

[Tyro]

My book on Excel 2007 tells me that in previous versions of Excel, if more
than one conditional formula evaluated as true only the first conditional
format was applied. That strongly suggests that if you put the AND formula
before the OR formula that your formatting will work. Have you tried that?

Tyro

Sadly, I am using 2003 :-/

If you're using Excel 2007, put the AND formula first and check Stop if
True

Tyro

Another stupid inquiry from me, this time regarding conditional
formatting.

I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank. So I created conditional formatting with two
formulas:

#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]

Clearly this isn't working, but I can't seem to figure out how to
write it so it works. It's shaded if there is any value in any cell,
and still shaded if all the cells have values. I'm sure the answer is
simple but it's just not coming to me. Thanks for the help!- Hide quoted
text -

- Show quoted text -

 

[RagDyer]

Try this as a *single* condition:

=AND(COUNTIF(A11,"<>")>=1,COUNTIF(A11,"<>")<4)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Sadly, I am using 2003 :-/

If you're using Excel 2007, put the AND formula first and check Stop if
True

Tyro

Another stupid inquiry from me, this time regarding conditional
formatting.

I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank. So I created conditional formatting with two
formulas:

#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]

Clearly this isn't working, but I can't seem to figure out how to
write it so it works. It's shaded if there is any value in any cell,
and still shaded if all the cells have values. I'm sure the answer is
simple but it's just not coming to me. Thanks for the help!- Hide quoted
text -

- Show quoted text -