Looking to make all Friday & Saturday's on an extensive worksheet gray - I am guessing this is done using conditional formatting. Anyone remind me on this - it has been a few years.
Thanks,
Mitch
Denver, CO
Looking to make all Friday & Saturday's on an extensive worksheet gray - I am guessing this is done using conditional formatting. Anyone remind me on this - it has been a few years.
Thanks,
Mitch
Denver, CO
You can use WEEKDAY function, e.g. with date in A1
=WEEKDAY(A1)>5
Friday has a weekday of 6 and Saturday 7 so that will format both
Note that excel thinks that a blank cell is a Saturday (!) so if A1 might be blank avoid formatting that by changing the formula to:
=AND(WEEKDAY(A1)>5,A1<>"")
Audere est facere
Hi Mitch,
Yes CF will do it, as would a VBA macro but better to keep things simple.
Assuming the date is in A1 then start the CF wizard and start a new rule and use the 'Use a formula....option.
In the rule enter
Formula:Please Login or Register to view this content.
and set the fill to grey.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I may be missing something here, guys. If I highlight cells that each contain a day A1 - Monday, A2 - Tuesday, etc. If i highlight all of them and enter the CF with =Weekday(A1)>=6, the entire range is turning the color. Am I missing a step?
-Mitch
Make sure you are using A1 and not $A$1. Cf will over-rule any regular formatting
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I take it that was the problem? Fairly common problem too. Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks