Hi

I have a very large worksheet (65 Columns x 5000 plus Rows) where one column
is
formatted in the UK Date format (dd-mm-yy) and is a manual entry.

I am required to turn the date red when it is 28 days or less from today's
date (if you were looking at being able to do it this way
=IF(TODAY()+28<=cell date,Red,black))

However, I am not allowed to add any more columns.

Is there a way of doing this without having to do each row individually with
either ...

Conditional Formatting
Formulae
Macro
Visual Basic

Many thanks in advance

--
Peter W