New answers tagged conditional-formatting
For conditional formatting, apply the following to A2: "Custom formula is" =AND(F2>TODAY(),G2>TODAY(),H2>TODAY())=TRUE (You can then indicate what the range of formatting should be, e.g., A2:A to get all A column except the header). To filter the content, use either Query or Filter. Here is an example with FILTER: ...
Use the condition that the Date is before =today()+7
Top 50 recent answers are included