Answer the question
In order to leave comments, you need to log in
Conditional formatting of a row in Google sheets depending on the date period. How to implement with one formula?
There is such a table. It is necessary that the entire line is highlighted if the current date falls within the "Week" range
. Who can advise? Thanks
Answer the question
In order to leave comments, you need to log in
The formula depends on the range. For example, if the date is in the upper left corner in cell A2, then the formula is:
A2 and A3 are cells with week boundaries in the first row.
The formula must be applied to the desired range, highlighting it from cell A2 (correct the addresses for yourself)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question