If I understand what you want, and that cells have the date value in them. See if this is what you are trying to do? In Cell A1 put =now() in Cell A2 put =a1+1 Copy A2 to A3:A33 Highlight Range A1:A33 Format/Conditional/Condition Select Formula is Enter Formula WEEKDAY($A1)=1 I added a new style GrayBold that set font to bold, and background to gray4 Than OK. On 18 Nov 2020 at 18:40, . wrote: From: "." <Look@iPadRing.net> Subject: [libreoffice-users] Easily format cells to bold and a certain background color To: users@global.libreoffice.org Date sent: Wed, 18 Nov 2020 18:40:04 -0500
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
+------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mikes@guam.net mailto:msetzerii@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- 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