Is there a way of being able to check whether 4 cells in a row have data in
or not.

On each row in my spreadhseet, If all 4 cells have content in them, i'd like
the cell to the far right of them to either change colour or have something
in it that tells me that all 4 cells have been populated.

firstly i put this in :

=if(and(isblank(a1),isblank(b1),isblank(c1),isblank(d1))," ","POPULATED")

the plan was to have the word "populated" in the far right cell if each of
the 4 cells had something in them. then i was going to use conditional
formatting to make it red.


....didnt work thoughh. I got the text "populated" even if only one of those
cells held data.

can you think of any way i can test if all 4 cells have content and if
so...flag it up?

the if statement is if(criteria, true do this, false do this) you pu
your

In your and statement it will work out exactly as you said as any no
blank cell will cause and to be false.

try

=IF(OR(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1),ISBLANK(D1)),
","POPULATED")

This will work out if any cell is blank, if any cell is blank the dat
is not populated and returns " " otherwise all the cells are populate
and 'Populated'

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=51682

How about:

=if(counta(a1:d1)<4,"","Populated")

You could use that same sort of formula in format|Condtional formatting. But if
you keep the "populated" formula, then you'll be able to use filter|autofilter
on that column to show just the blanks (or just the populated).

Doing that same kind of thing with colors or conditional formatting becomes a
real pain.

Karlos wrote:
>
> Is there a way of being able to check whether 4 cells in a row have data in
> or not.
>
> On each row in my spreadhseet, If all 4 cells have content in them, i'd like
> the cell to the far right of them to either change colour or have something
> in it that tells me that all 4 cells have been populated.
>
> firstly i put this in :
>
> =if(and(isblank(a1),isblank(b1),isblank(c1),isblank(d1))," ","POPULATED")
>
> the plan was to have the word "populated" in the far right cell if each of
> the 4 cells had something in them. then i was going to use conditional
> formatting to make it red.
>
> ...didnt work thoughh. I got the text "populated" even if only one of those
> cells held data.
>
> can you think of any way i can test if all 4 cells have content and if
> so...flag it up?
>
>

--

Dave Peterson