Good evening, I would need to color some cells (which you see in the attached file) of blue if the day of the week is Monday but it must not be in the list of holidays.
Example D10: E10 I would not like the color, even if it is Monday, but it is included in the holiday sheet.
Thank you
Use this rule for your conditional formatting:
Formula:
Please Login or Register to view this content.
Thanks to your help I have changed this way:
thank you again and, if you want, you can also see this 3d that I can not solve
Please Login or Register to view this content.
https://www.excelforum.com/excel-for...ml#post5272200
Thank you
Ah, mi dispiace, I had it backwardsglad you corrected it.
When I saved the attached it warned of Compatibility issues. It was not specific beyond that. NETWORKDAYS.INTL will not work in your Excel 2007 but should in 2010.
Conditional formatting rule applied to D5:E33Formula:Please Login or Register to view this content.
Dave
Hi thanks Flame your solution works too.
This I put solved
If you can help me with the problem indicated in the link:
https://www.excelforum.com/excel-for...ml#post5272200
thank you
You are welcome. Glad to help. Thanks for the feedback, added rep and marking your thread Solved.
please, could you help me in the other thread? reported in the link above?
if the problem is not clear I can explain it.
thank you
I have looked at it. I have subscribed to it so will continue to monitor it.
At the moment I don't understand its meaning. When I have questions I'll ask them back at that thread.
Thank you I tried to explain better in another post
in the thread.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks