Hi there!
I am trying to highlight the weekends in this spreadsheet.
I used the formula
=OR(WEEKDAY(H3)=7,WEEKDAY(H3)=1)
Unfortunately only the cells containing the weekend are highlighted (Image 1).
weekend1.JPG
I want the entire column of that weekend to be highlighted (I manually did this in Image 2).
weekend2.JPG
Could you please tell me which formula I need to use instead?
Thank you!
You would need to select all the rows and use the formula:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks