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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 08:16 AM
Related:
- To format columns based upon value in a cell
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- How to change time format in whatsapp - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2010 at 07:41 AM
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
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".
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2010 at 08:16 AM
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"))
=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"))
