VBA Conditional Format

Hi All,

I'm having an issue with a conditional formating reference. Here is my current code:

Please Login or Register  to view this content.

The dates in G1 and J1 are user defined, but any dates in columns C or D are static. Everything works fine so far unless the user enters a date in G1 that is less than any date in Column C, which goofs up all the formatting.

My question is, would there be any way to check if the date in G1 is less than any date in column C, then perform an event if true?

Something like:

Please Login or Register  to view this content.

(which doesnt work).

Any help would be greatly appreciated, thanks!

Seems to me you got this yourself, so I guess I must be missing something

Please Login or Register  to view this content.

Hello Bob, thanks for the reply!

When I run that code I get a message box for every instances of a date in column C, which is several hundred, also it runs regardless of the date value in G1.

Thanks

The closest I have gotten is this:

Please Login or Register  to view this content.

Which always gives the message box regardless of date for some reason. Perplexing!

What values do you have in G1 and C2?

G1= 7/15/14
C2= 3/11/14

Thanks

This works for me, assuming you have real dates in those cells

Please Login or Register  to view this content.

Thanks Bob, it works well execpt for the message box showing up regardless of date, so I ended up deleting the message box and using the code to just exit before the rest of the conditional formating.

Appreciate the help!