[libreoffice-users] conditional formatting based on day of week

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