Try this: Highlight full range of Area In my test A1:F419 For Condition 1 Set to Formula is: Formula to weekday($a1)=1 Weekday returns 1 for Sunday on my setup (1 to 7) Just select ERROR as Style (for testing) With the $a1 it will hightlight whole row of data instead of just that column. On 28 May 2021 at 18:01, Gary Dale wrote: To: LibreOffice Users <users@global.libreoffice.org> From: Gary Dale <gary@extremeground.com> Subject: [libreoffice-users] conditional formatting based on day of week Date sent: Fri, 28 May 2021 18:01:38 -0400
It's been years since I tried to do anything with conditional formatting and now I can't seem to get it right. I have a spreadsheet sorted in date order where I want to highlight the start of each week (i.e. Sunday) to divide up the data visually. My idea was to test if the date cell in the current row was a Sunday, so I constructed the formula as: (WEEKDAY(ADDRESS(ROW(), "B"), 2) = 0) where column B contains the dates. I apply that condition to a selection that excludes the column titles and set the formatting to a background highlight. Unfortunately it doesn't do anything and I can't figure out why. Any ideas? Thanks in advance. -- 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