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),isblan k(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