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
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