Highlighting Data

[howard]

I need to write VBA code that will highlight the data in columns A to F where the date in column B 60 days past the current date in cell B2 for eg if the date in B7 is 31/07/2006 and todays date is 07/10/2006, then all the data in A7 to F7 must be highlighted in Grey

Your assistance will be most appreciated.

Howard

 

[dave3009]

You can use conditional formating.

Highlight area you want to apply format to then Format>>Conditional Format

Formula is >> =NOW()-$B7>60

Set format to what ever you want


HTH


Dave

 

[howard]

Hi Dave

Thanks for the help.

I have another problem, regarding VBA in finding & Replacing data which I have posted on board, but have had no replies.

Would it be possible for you to forward your email address so that I could email you the file? If so please send me your email address to howard.cohen@ecmpe.co.za

Regards

Howard

 

[dave3009]

Hi Howard

You should not post your e-mail address in a post rather use something like

howard.cohen_NO_SPAM@ecmpe.co.za

This way you don't get spyware e-mailing you stuff

I'll e-mail you

KR

Dave