J
J
jeedejjjj2019-01-07 01:12:39
Google Sheets
jeedejjjj, 2019-01-07 01:12:39

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
5c327d1d12b08855179238.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-01-07
@Volunteer

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 question

Ask a Question

731 491 924 answers to any question