Tag Info

New answers tagged


The accepted answer mentions colours that are not mentioned in the question and only looks back. Also "Date is before" "in the past week" does not highlight dates within seven days of today. I suggest a Conditional formatting Custom formula is of the type: =and(A1>today()-7,A1<today()+7) where six days before today, today and six days after ...


I think @Vembu's solution works but might be simplified in two ways: Apply one of the colours as normal fill to both columns (or the required range for those columns). Then just use one CF rule (to overwrite that 'standard' formatting, when appropriate). All relevant cells in B and D are either one colour or the other, for which one CF rule is ...

Top 50 recent answers are included