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
Configuration: Windows XP Firefox 3.0.4
And statement in conditions excel Excel formula print automatically on condition Excel active cell color change condition if Excel conditional count Excel conditional formatting formula rank Excel conditional formatting if statement Excel conditional formatting sort Excel conditional formatting specific text in vba Excel count if 2 conditions apply Excel date format Excel if background color Excel macro to delete rows based on condition Excel viewer How to conditional format with 6 month date in excel How to set colour based on condition excel If between condition excel vb Insert a date when a condition is met in excel More than 3 conditional formats in excel 2003