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

Thanks. Good solution.

On 2021-05-28 20:38, Michael D. Setzer II wrote:
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.