Formula Help for

I am trying to make a row turn red if both the Interview date AND Time Slot are the same. I was able to do this with just Interview dates being dups but am getting stuck with how to also add Time Slot into the mix. I used a helper column to with the formula

=COUNTIF([Interview Date]:[Interview Date], [Interview Date]@row)

and then conditional formatting to turn red if more than 1.

I tried =COUNTIFS([Interview Date]:[Interview Date], [Interview Date]@row), AND([Time Slot]:[Time Slot], [Time Slot]@row)) but got and unparseable error.

Any thoughts?

Find more posts tagged with

Accepted answers

All comments

David Stokes

Have you tried doing this with just Conditional Formatting in lieu of formulas? You can add conditions to a new rule.

Amy F

@David Stokes I still think I need some what to know if the date AND time are dups anywhere in the 2 columns. Am I making this harder than it should be?

Paul Newcome

Remove the closing parenthesis after [Interview Date]@row as well as the entire AND function (including parenthesis).

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.