Formula to highlight a column in RED when date is past the task end date and progress is <100%

Here is what I have:

Any time the task end date is past today's date and the progress is less than 100% complete, I want this to be highlighted in red. Below is the formula I am using but it does not seem to work. Please help.

=AND(date>=task_start, date<=task_end,task_progress<0.1)

Date = the weekly dates in the row in BLUE (1/4, 1/11 etc)

Task_start = Start column

task_end - end column

task_progress = Complete column

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

Have you looked at conditional formatting? This seems to be a perfect fit for that rather than needing a formula.

BobbyS

Yes, using conditional formatting and I have pasted what I have in it.

David Tutwiler

I think the issue is in how you're marking for 100% complete. In your formula you're saying IF less than 0.1. I think you just want to say if < 1

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.