Good morning
I was trying to color the line of holidays and Sundays of a Google sheet.
I encounter these problems
if those only on Sundays
1 = WEEKDAY ($ A4.2) = 7 it's ok, color the whole line from A: Z
2 = MATCH ($ A4, INDIRECT ("Holiday! D2: D"), 0)
those holidays ok.
If I combine the Sunday formula 1 with that of holidays: 2
= OR (WEEKDAY ($ A4,2) = 7, MATCH ($ A4, INDIRECT ("Holiday! D2: D"), 0))
I only color the lines of holidays 2 no longer Sundays 1
Is it possible to make a single formula or do you have to do 2 separate ones,
one for Sundays and the other for holidays?
what can i change i am just starting with Google sheets i am not very practical.
Thanks
Bookmarks