This is a short post but it took me a while to figure it out, so I thought I'd post it. I have a long list of dates in a spreadsheet, and wanted to have Saturdays and Sundays formatted differently so that they stood out. I tried a number of things in Conditional Formatting, until I hit on this one.<\/p>\n
Highlight the column you want to apply this to and bring up the Conditional Formatting dialog from the Format menu. Set a style in the Style dropdown (I chose 10% grey background for eg, and called it 'greyed'. Change the other dropdown to \"Formula Is\", and put this in the box:<\/p>\n
OR(WEEKDAY(CELL(\"contents\"))=1, WEEKDAY(CELL(\"contents\"))=7)<\/p>\n
That's basically it. This works in LibreOffice and OpenOffice, and should also work in Excel too, as the functions are the same.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is a short post but it took me a while to figure it out, so I thought I'd post it. I have a long list of dates in a spreadsheet, and wanted to have Saturdays and Sundays formatted differently so that they stood out. I tried a number of things in Conditional Formatting, until … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-216","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/comments?post=216"}],"version-history":[{"count":0,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/posts\/216\/revisions"}],"wp:attachment":[{"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/media?parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/categories?post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/play.datalude.com\/blog\/wp-json\/wp\/v2\/tags?post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}