Morning all,
I've managed to pull together the code below which almost does what I need but the formula creates a conditional format with an absolute reference when I need it to be relative. How can I amend the line below to achieve what I need?
Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=MONTH(" + InvDate + ")=1"
If you have any queries or need me to explain anything further just give me a shout.
Thanks in advance,
Snook
Please Login or Register to view this content.
Bookmarks