if one of the cells from the range is filled

[siemasz]

Hello Everyone!

I have a problem writing formula to ensure user filled both columns in case he fills any of them.

lets say we have a table containing names and last names
a - name b - lastname

robert	mcdonalds
stevens

<tbody>
</tbody>

And we have status summary in C1 cell.

then row 1 is correct but if a2 is filled and b2 is not then in c1 cell value we want to have a message: form not completed.


any hint on writing one formula in c1 for that?
Thank You!

 

[AlanY]

how about using conditional formatting on Col B with =AND(ISBLANK(B1),ISTEXT(A1))?