Tag Info

New answers tagged

2

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: ...


-3

Use the condition that the Date is before =today()+7



Top 50 recent answers are included