I have the date of Overtime in one column. If any of those dates in Column B match a Saturday Date in Column J, I would like for it to be highlighted. I have attached a sample spreadsheet. I highlighted 3 cells that I would like for the conditional formatting to find and highlight.
try using
=WEEKDAY(B2,1)=7
weekday returns a number based on day of week for that date
the 1, you can enter various options on what day to use a 1
1 = sunday = 1
2 = monday =1
is column J just to find Saturdays ? or are those the only Saturdays you want to match ?
you could also use a countif()
=COUNTIF($J$2:$J$36,B2)>0
Last edited by etaf; 12-21-2021 at 11:10 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Done:
Formula:
Please Login or Register to view this content.
=AND(ISNUMBER(MATCH(B2,$J$2:$J$100,0)),WEEKDAY(B2,2)=6)
applies to =$B$2:$B$100
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks