LinkBack URL
About LinkBacks
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
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
apply this conditional formula to C1
Formula:
=WEEKDAY($C1,15)<3
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
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.
Thank you humdingaling
Last edited by jeffreybrown; 06-06-2018 at 08:17 PM. Reason: Removed full quote!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks