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?