+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting a row if cell is Friday or Saturday

  1. #1
    Registered User
    Join Date
    01-13-2017
    Location
    EgYpT
    MS-Off Ver
    2010
    Posts
    36

    Question Conditional formatting a row if cell is Friday or Saturday

    Hi every one

    i need help to make it

    Conditional formatting any row in sheet if any cell in column is Friday or Saturday

    the dates in column C and not in sequence

    02/06/2018
    05/06/2018
    07/06/2018
    08/06/2018
    11/06/2018
    14/06/2018
    16/06/2018

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Conditional formatting a row if cell is Friday or Saturday

    apply this conditional formula to C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    apply to area
    =$1:$7
    increase 7 to how many rows you want the conditional format to work

    attached file i did it to row 26
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-13-2017
    Location
    EgYpT
    MS-Off Ver
    2010
    Posts
    36

    Re: Conditional formatting a row if cell is Friday or Saturday

    Thank you humdingaling
    Last edited by jeffreybrown; 06-06-2018 at 08:17 PM. Reason: Removed full quote!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Conditional formatting a row if cell is Friday or Saturday

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. include dates excluding weekdays Friday and Saturday
    By alipezu in forum Excel General
    Replies: 9
    Last Post: 11-20-2017, 05:08 AM
  2. Find previous Saturday and next friday dates given a date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-31-2016, 08:48 AM
  3. [SOLVED] Macro to Fill Cells with H if it is a Friday or a Saturday
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2014, 03:25 PM
  4. Count number of days minus Friday and or Saturday
    By aj34321 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2013, 06:22 PM
  5. [SOLVED] How do I set NETWORKDAYS to regard friday and saturday as weekend
    By Shay.C. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2006, 03:29 AM
  6. [SOLVED] Starting work period on a Saturday and ending on a friday
    By JLyons in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  7. Starting work period on a Saturday and ending on a friday
    By JLyons in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2005, 10:06 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