Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


Hi,
I am assuming your dates are in column "A", and the data in columns B
and next. You can easily do this with conditional formatting:

1) Select your dates and data
2) From the Format menu > Conditional
3) On the Conditional Formatting panel, in the first drop-down, select
"Formula is"
4) Enter the formula: WEEKDAY(INDIRECT(ADDRESS(ROW(),1)),2)=7
5) Select a style to apply. I would say "Accent 3" is the one you are
looking for, but you can create your own and select it there
6) Hit OK. Your Sundays should now be shown in Accent 3 (bold with grey
background)

What the formula does:

WEEKDAY(date,2): returns the day of week, with Sunday being day 7
ADDRESS(ROW(),1): Dynamically creates the cell address of your date; if
you are on the second row, this formula returns A2
INDIRECT(): Returns the content of; so INDIRECT(ADDRESS(ROW(),1)) on
row 2 returns the content of A2 (a date since your dates are in column
A)
WEEKDAY()=7: Sunday

If you want to upload a file, you can go directly on the
nabble.documentfoundation.org page. I believe you can upload a file
with your message from there. You can also send it to me directly if
you're stuck and I'll give you a hand.
I hope this helps.

Rémy.

Le mercredi 18 novembre 2020 à 18:40 -0500, . a écrit :

I
          record the weather for each day of the year....it's a hobby.


It
          would be simplest if Calc could format each Sunday in bold
          font and a gray background.  With many Sundays in a year it
          takes too long to manually change each year's Sundays.


I have
          sample Calc sheet I use but don't know where I can upload it
          so you can take a look at it.




Thanks,




Peter
          Dutton



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.