Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Conditional formatting to ID identical fields

Topic Labels: Formulas
Solved
Jump to Solution
274 4
cancel
Showing results for
Search instead for
Did you mean:
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
18 - Pluto

Welcome to the community, @Dena_Mendelsohn! :slightly_smiling_face:

This formula should work for you:

``````IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)``````
4 Replies 4
18 - Pluto

Welcome to the community, @Dena_Mendelsohn! :slightly_smiling_face:

This formula should work for you:

``````IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)``````
5 - Automation Enthusiast

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!

18 - Pluto

Yes, that’s correct!

5 - Automation Enthusiast

This works! Thank you @ScottWorld!