Highlight "e" in duration column

Hi, I'm trying to highlight all tasks with an "e" in the duration column, since "e" overrides all weekends and holidays I need to be mindful as to not forget an "e" somewhere when the schedule changes.

The Conditional Formatting does not work to highlight it by just saying "if duration contains 'e' then apply this format…". For some reason it does not catch the "e" modifier not matter what i type, "e" stars around it etc.

How can i acomplish this task?

thanks//Patrik

Find more posts tagged with

Sheets

functionality

Timeline View

Accepted answers

All comments

kowal

Hi Patrik,

If conditional formatting is not catching "e" from duration column have you tried using the formula with =if statement? you can create new column (checkbox) and use formula: =IF(CONTAINS("e", Duration@row), 1, 0) let me know if it works.

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.