Libre Calc / Excel - conditional formatting: WEEKDAY()
by czezz from LinuxQuestions.org on (#5A1EF)
Hi,
As you can see in the attachment I created calendar in row 2.
With conditional formatting, I have highlighted all weekends with orange color :
Code:=OR(WEEKDAY(D2)=1;WEEKDAY(D2)=7)I would like to add now another condition:
whenever there is =OR(WEEKDAY(D2)=1;WEEKDAY(D2)=7) - it stands for: Saturada and Sunday - highlight whole column (or at least 10 rows of that specific column).
You can better see an example on columns: I,J in attached screenshot.
Does anyone know how to do that?
What I have came up for now, is the following condition but this is just static and does not refer to WEEKDAY()
Code:=MOD(COLUMN();7)=1
Attached Thumbnails
As you can see in the attachment I created calendar in row 2.
With conditional formatting, I have highlighted all weekends with orange color :
Code:=OR(WEEKDAY(D2)=1;WEEKDAY(D2)=7)I would like to add now another condition:
whenever there is =OR(WEEKDAY(D2)=1;WEEKDAY(D2)=7) - it stands for: Saturada and Sunday - highlight whole column (or at least 10 rows of that specific column).
You can better see an example on columns: I,J in attached screenshot.
Does anyone know how to do that?
What I have came up for now, is the following condition but this is just static and does not refer to WEEKDAY()
Code:=MOD(COLUMN();7)=1
Attached Thumbnails