Hi Sukh,

Try using Excel's Conditional Format feature.

If you are not familiar with this feature, see Debra Dalgleish at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"Sukh" <Sukh@discussions.microsoft.com> wrote in message
news:31B68F5C-D6EC-42B5-95C6-CACC4D7894F1@microsoft.com...
> Firstly a bit of background. I have a report which is run from a seperate
> database to determine candidates who have not been contacted for more than
> six weeks. I export the results of the report into excel and run a macro
> to
> delete uneccessary information, and to "pretty up" the spreadsheet.
>
> Information on the spreadsheet is calculated with a formula which is input
> bu the macro, and determines the number of weeks since the candidates were
> last contacted, i.e. =(today()-b3)/7, in column E. I was wondering
> whether
> it was possible to edit the code to determine how long it has been since
> the
> cadidate was last contacted, and based on that, colour the cell either,
> red,
> yellow or green.
>
> Thanks in advance