Hi,
I have some dates in range D14 : D20.
I would like a conditional formatting so that if a date in above range (D14:D20) is 20 days away or less from today's date then the font becomes red (currently black).
I can apply a formula in conditional formatting to each cell and it works but this is time consuming (e.g. starting with cell D14, formula = D14-(today's date)<=20 then font becomes red).
How can I apply the formula to the whole range (i.e. D14:D20) directly without having to insert conditional formatting to each cell individually?
Is there a way?
Thanks,
Nic
I have some dates in range D14 : D20.
I would like a conditional formatting so that if a date in above range (D14:D20) is 20 days away or less from today's date then the font becomes red (currently black).
I can apply a formula in conditional formatting to each cell and it works but this is time consuming (e.g. starting with cell D14, formula = D14-(today's date)<=20 then font becomes red).
How can I apply the formula to the whole range (i.e. D14:D20) directly without having to insert conditional formatting to each cell individually?
Is there a way?
Thanks,
Nic