Thread: Conditional Formatting in VBA for expired dates

Hi there

I am attempting to create, what might be a very simple macro in VB for Excel 2007, but I am having a lot of trouble.

I have two columns that need to be referenced and conditional formatting applied to one of them (column K).

The first column (H) shows the stage. I am only concerned with highlighting items in column K that are not listed as Engaged or Lost & Leaked in column H. The ulimate aim is to highlight expired dates (dates less than today) in column K for possible work that has not been completed.

I have tried to put it as simply as I can below:


'If cell in column H is not equal to engaged or lost and leaked then look at column K

'If cell in column K is blank then do nothing

'If cell is less than NOW()

This needs to loop until there are no values in Column H.

Any direction or help with this would be much appreciated!

Anna