To format columns based upon value in a cell

Closed
Teesta - Aug 18, 2010 at 07:06 AM
rizvisa1
Posts
4479
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

5 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
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
0
Please let me know the code for it.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
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
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

Didn't find the answer you are looking for?

Ask a question
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
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"))
0