AND Function

  • Thread starter Thread starter Kevin McClement
  • Start date Start date
K

Kevin McClement

Good morning all,

I'm trying to find an easy way to do this calculation:

I have 3 columns of data, if there is more than 1 entry
in any of the rows, i'd like to do a conditional format
based on there being 2 or more entries in the same row. i
started with this:

=AND($C4<>"",$D4<>"",$E4<>""), this one will not color
the row if all three are not filled. i think what i'll
require is 3 OR's like so:
<> = =, = = <>, and = <> =. this way, when one is false,
it can go through the other two and if none of them are
true, it won't color them at all which is correct.

TIA
Kevin McClement
 
Kevin,

Try this: =SUMPRODUCT(($A2:$C2<>"")*1)>1

The row of the $A2:$C2 range must agree with that of the active (white) cell
of your selection. Change the formula as necessary.
 
Worked great Earl, thanks a lot.
-----Original Message-----
Kevin,

Try this: =SUMPRODUCT(($A2:$C2<>"")*1)>1

The row of the $A2:$C2 range must agree with that of the active (white) cell
of your selection. Change the formula as necessary.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Kevin McClement"


.
 
Back
Top