+ Reply to Thread
Results 1 to 3 of 3

Condotiona Formatting Based on Days of the week

  1. #1
    Registered User
    Join Date
    12-04-2021
    Location
    London England
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2212 Build 16.0.15928.20000) 64-bit
    Posts
    24

    Condotiona Formatting Based on Days of the week

    Hi Everyone

    So I am applying conditional formatting to the range E6 to H36 to make them all red when cell in column D are either "Sat" or "Sun" but it only applies in column E even if the condition is selected to apply in all the range.

    Any help? what am I doing wrong?
    Attached Images Attached Images

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Condotiona Formatting Based on Days of the week

    Lock the D with a $.

    i.e. =COUNTIF($D6,"Sat")

  3. #3
    Registered User
    Join Date
    12-04-2021
    Location
    London England
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2212 Build 16.0.15928.20000) 64-bit
    Posts
    24

    Re: Condotiona Formatting Based on Days of the week

    This worked thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting for days of the week
    By bryanhope in forum Excel General
    Replies: 3
    Last Post: 06-19-2017, 03:38 PM
  2. Conditional Formatting for different days of the week.
    By codypear90 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2016, 10:48 AM
  3. Conditional formatting on certain days of the week
    By MarkoFerjancic in forum Excel General
    Replies: 6
    Last Post: 10-17-2016, 04:19 PM
  4. Replies: 2
    Last Post: 10-03-2016, 08:35 AM
  5. Conditional formatting based on text ( week days)
    By gfmout in forum Excel General
    Replies: 4
    Last Post: 12-16-2013, 03:34 PM
  6. Conditional Formatting Days of the Week
    By braydon16 in forum Excel General
    Replies: 3
    Last Post: 01-13-2011, 03:43 PM
  7. conditional formatting/days of the week
    By ki_cz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2008, 05:29 AM

Tags for this Thread

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