Flag or Conditional Formatting?

I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that?

I thought I had figured out a work around by using the flag function but I can't seem to get the formula to work. This is what I'm using:

What am I doing wrong? Any suggestions to either use conditional formatting or the flag function (by correcting the formula)?

Find more posts tagged with

Sheets

Formulas

Automations

Conditional Formatting

Project Management

Accepted answers

Kelly Moore

Hey @Morgan E Kelly

Try this

=IF(OR([Date Planned ED-P]@row <= [Earliest Date]@row, [Latest Date]@row <= [Date Planned ED-P]@row), 1, 0)

cheers

All comments

Kelly Moore

Hey @Morgan E Kelly

Try this

=IF(OR([Date Planned ED-P]@row <= [Earliest Date]@row, [Latest Date]@row <= [Date Planned ED-P]@row), 1, 0)

cheers

Morgan E Kelly

I had to take out the "=" but the OR worked! Thanks so much!

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.