Hi All,
I'm new here.
I have a timesheet for our employee, weekends are highlighted, my dilemma is if a holiday falls on a Sunday I'd like the conditional formatting to highlight a day after, Monday. Please help, thanks,
I have 2 conditional formatting Rule in the attached file:
1.=WEEKDAY(E$5,2)>6
2.=COUNTIF(PH!$A$2:$B$12,E$5)>0
Attached file is the table I created.
Hope someone can help me in this matter.
Thanks!
Last edited by SeeMun; 07-21-2016 at 05:37 PM.
is anyone could help me? or is there any post in this forum could help me on this?
SeeMun, welcome to the forum
Our rules require you to wait at least a day before "bumping" your thread.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Edited Mistake in original formula.
Try applying this CF formula to E6:S33 with E6 the active cell.Formula:
Please Login or Register to view this content.
Last edited by FlameRetired; 07-21-2016 at 01:37 AM.
Dave
thank you for the note.
You are welcome.
Does the formula do what you expect?
Yes, the formula help me a lot! Thank You very much! Really appreciate your help!
Glad to hear it. You are welcome. Thank you for the feedback and the rep.
You help to solve my problem, I'm the one who should say Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks