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

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 
From:                   Gary Dale <>
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:
Posting guidelines + more:
List archive:
Privacy Policy:

 Michael D. Setzer II - Computer Science Instructor 
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.