To format columns based upon value in a cell

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I want to make a leave tracker in Excel 2007 for the employees of my project. I am designing it per day per month basis. In that I want all the holidays including saturdays and sundays to be grayed out.
Is it possible, please help.
Regards,
Teesta

5 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Weekends are easy. other holidays, some how system needs to know what are those. Independence day is a very common such holiday that system would not know. You ask, is it possible. More often things are possible, then not and in this case it is possible
0
Please let me know the code for it.
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Code for what part ?

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
please find the workbook at http://www.editgrid.com/user/teestaghosh/Leave_Tracker I want to gray out all saturdays and sundays as well as the holidays mentioned in the sheet named "list".
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Well you can use this formula for conditional format.

=OR(WEEKDAY(C$2,2)>5,C$2=DATEVALUE("8/24/2010"),C$2=DATEVALUE("9/2/2010"),C$2=DATEVALUE("9/10/2010"),C$2=DATEVALUE("11/4/2010"),C$2=DATEVALUE("11/5/2010"),C$2=DATEVALUE("12/27/2010"),C$2=DATEVALUE("12/28/2010"))
0