Another Conditional Excel Help Req.

Closed
meddel - Dec 1, 2008 at 01:17 PM
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 - Dec 2, 2008 at 05:13 AM
Hello,

I am wondering if could get some help with an excel VB macro.

What I'd like it to do is this: Columns E, G, I, K, M, O, Q, R, S, U, W & X-AI all contain dates in yy-mm-dd format.
I would like the macro upon loading the Master list to run a check on all the dated columns to and if the current date equals the month and year listed in the column then the cell be indicated in red. I am not sure if this matters but the dates in the columns are also hyperlinked off to other documents.

Any help would be deeply appreciated.

RG
Related:

1 response

sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 31
Dec 2, 2008 at 05:13 AM
I think you have to do it manually...
0