Conditional Formatting for cells in one column

[Nick70]

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

 

[Fluff]

Just select D14:D20 & then apply the rule.

 

[Nick70]

Thanks.

 

[Fluff]

You're welcome & thanks for the feedback.