Automatic background change in perpetual calendar

Discuss the spreadsheet application

Automatic background change in perpetual calendar

Postby Ron Hargrove » Fri Jan 10, 2020 2:56 pm

First of all, I have no training in spreadsheets but am just figuring this out as I go.

I am trying to create a perpetual quarterly date planner in Calc. Each date has three cells: Day number, day of week, and a blank cell for either inserting data or writing into on the printed sheet. The day of week outputs the day of the week using the format code "DDD". What I would like to do is to automatically shade all 3 cells with a light gray background if the DDD format code returns "Sat" or "Sun" but otherwise leaves the cells unshaded. It isn't that hard to manually shade the cells, but it would be nice if the spreadsheet would do it automatically moving forward.

Is there a simple way to accomplish this?
OpenOffice 6.0.7.3 on Linux Mint
Ron Hargrove
 
Posts: 1
Joined: Fri Jan 10, 2020 2:27 pm

Re: Automatic background change in perpetual calendar

Postby RusselB » Fri Jan 10, 2020 4:50 pm

Use Conditional formatting with the formula set to weekday()>5

or at least I think that's the number. Check the help file as I can't right now
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6157
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: fiona87 and 18 guests