To format columns based upon value in a cell

Closed
Teesta - Aug 18, 2010 at 07:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 08:16 AM
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

Related:

5 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 18, 2010 at 07:37 AM
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
Please let me know the code for it.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 18, 2010 at 07:41 AM
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
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".
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 18, 2010 at 08:16 AM
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"))