How to highlight weekend dates dynamically - Ask Your Excel Question #5

[@vikashrajak8948]

Just wow👍👍👍👍👍

[@indzara]

Thank you for sharing your valuable feedback.
Best wishes.

[@mobarakhossain2287]

Thanks for your very helpful video. My question is how to hide the holidays ?

[@indzara]

Thanks.
1. Hiding the rows will require macros, I believe.
2. To make it appear as hidden: You can conditional format the holidays to be white font and white fill - the cell will be there but not visible with text.
3. Other Option: We can change the formula in such a way that column I will only display non-holiday dates. That formula will be different but it will skip holidays/weekends.
Thanks & Best wishes.

[@lynnlaenwekhin]

can u tell me a formula for whole rows to hightlight

[@indzara]

When selecting cells to apply conditional formatting, please select the entire row.
This is usually not recommended, as conditional formatting can make the file slow, if applied to a lot of cells.
Best wishes.

[@mobarakhossain2287]

how if I want to hide the holidays from range of date when I tick the check box. Thanks

[@indzara]

Thanks.
1. Hiding the rows will require macros, I believe.
2. To make it appear as hidden: You can conditional format the holidays to be white font and white fill - the cell will be there but not visible with text.
3. Other Option: We can change the formula in such a way that column I will only display non-holiday dates. That formula will be different but it will skip holidays/weekends.
Thanks & Best wishes.