And it is not a programming issue:

I need a simple macro that will search lets say..column C and highligh
red the cells that contain todays date (current date) and highligh
yellow any other cell in the column that is 15 days in the future fro
todays date?

Users of Excel 97 or Excel 2000 can take advantage of the ne
Conditional Formatting option. Let's cover how to do this manuall
without a macro first.

Move to cell C1.
From the menu, choose Format, Conditional Format
In the left side of the dialog, change the drop down to read "Formul
is"
In the right side of the dialog box, enter: =INT(C1)=TODAY()
Click format, Click Patterns, pick Red. Click OK
Click Add...
In the left side of the dialog, change the drop down to read "Formul
is"
In the right side of the dialog box, enter
=AND(INT(C1)TODAY(),(INT(C1)-TODAY())<16)
Click Format, Click Patterns, Pick Yellow. Click OK.
Click OK to finish assigning this conditional format to cell C1.


http://www.mrexcel.com/tip037.shtml

Thanks Mr Excel

--
Message posted from http://www.ExcelForum.com