Conditional formatting to ID identical fields

I want to create an airtable column that will say Yes if two other columns are identical, say No of those other columns are not identical, and say N/A if one of the columns is empty. Is there a way to do this?

For example:
Column A says Cow
Column B says Cow
So conditionally formatted Column C says Yes

Column A says Cow
Column B says Duck
So conditionally formatted Column C says No

Column A says A
Column B is blank
So conditionally formatted Column C says N/A

I’ll take any solution, doesn’t have to be conditional formatting.

Thanks ahead!

Welcome to the community, @Dena_Mendelsohn! :slight_smile:

This formula should work for you:

IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)

Thanks @ScottWorld! If my columns are actually sentences (rather than “A” or “B”) do I just put the sentence column name in {brackets}? Very much appreciate your help on this!

Yes, that’s correct!

1 Like

This works! Thank you @ScottWorld!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.