Results 1 to 2 of 2

Highlight if there is more than 6 consecutive cells containing the text ''Regulated Work''

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2022
    Location
    Howlong, Australia
    MS-Off Ver
    MS 365
    Posts
    1

    Highlight if there is more than 6 consecutive cells containing the text ''Regulated Work''

    Hi members - I was wondering if someone could help me with what should be an easy formula. I need a formula in conditional formatting to highlight in red if there is more than 6 consecutive cells in a row with the same text "Regulated Work" - this is required to highlight if someone was tasked to work more than 6 days straight in a roster. This formula is almost getting it but Highlights when there is more than 6 occurrences in a row and not 6 consecutive occurrences only:
    =SUM(--($4:$4="Regulated Work"))>6 and i need it to be applied to the whole sheet but only highlight if row value is more than 6 consecutive "Regulated Work" occurrences.


    Capture.PNG

    Driver Roster Example.xlsx
    Last edited by Muffinman72; 10-04-2022 at 11:35 PM. Reason: Improve Heading

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting Formula Needed
    By jeff17408 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-08-2017, 02:42 PM
  2. [SOLVED] Help please! Formula needed for conditional formatting.
    By SLIDE1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2016, 12:23 PM
  3. Conditional formatting formula needed
    By freckles81 in forum Excel General
    Replies: 6
    Last Post: 05-29-2014, 10:34 AM
  4. [SOLVED] Conditional Formatting formula needed!
    By kgowett in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2014, 03:47 PM
  5. Formula needed for conditional formatting
    By NEHicks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 11:28 AM
  6. Conditional Formatting Formula Needed
    By AJT82 in forum Excel General
    Replies: 2
    Last Post: 10-08-2011, 05:15 AM
  7. Conditional formatting formula help needed
    By gloworm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2011, 03:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1