google sheet conditional formatting of same row

Question

In the conditional formatting, how to make the first column of data meet the date conditions, the same row of data will show the background color.

question from:https://stackoverflow.com/questions/65878562/google-sheet-conditional-formatting-of-same-row

Answer 1

For "Apply to range", you specify the entire range of cells you want to potentially be highlighted. Then, use a custom formula that refers to the exact cell in the first row of the range that you want to deal with, and google sheets will infer the rest of the rows. In your example, set range equal to A2:D20, and the custom formula to =$A2<TODAY().