LinkBack URL
About LinkBacks
Hi guys, 09/04 is my national vacation. I have 2 problems:
1. Use Conditional Formating to bold date which is vaction or sunday.
2. Everyone who works on vacation or sunday that will be multiply 2.
Hi guys, 09/04 is my national vacation. I have 2 problems:
1. Use Conditional Formating to bold date which is vaction or sunday.
2. Everyone who works on vacation or sunday that will be multiply 2.
in j9 copy paste below then hold control and shift and hit enter and release all three keys then drag down up till j28
=IF(OR(ISNUMBER(MATCH(TRUE,G9=$E$9:$E$11,0)),(TEXT($G9,"DDD")="Sun")),I9*2,I9)
use same formula in conditional formatting.
find attached ! Go to conditional formatting rule
if your date of vacation expand then change =IF(OR(ISNUMBER(MATCH(TRUE,G9=$E$9:$E$11,0)),(TEXT($G9,"DDD")="Sun")),I9*2,I9) red part to manage the dates !
Last edited by hemesh; 04-16-2014 at 04:21 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks