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
[TABLE="width: 500"]
<tbody>[TR]
[TD]robert[/TD]
[TD]mcdonalds[/TD]
[/TR]
[TR]
[TD]stevens[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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