Conditional Interior Color

[Chris1201]

I created a worksheet for training, and I'm just trying to polish it off. The last thing I need to do to it is create a macro on the sheet's VBA that, when the loss date is less than the current date, colors the interior of those cells in red.

Here is an example of what I'm looking at.

[DonkeyOte]

why not just use Conditional Formatting ?

http://www.contextures.com/xlCondFormat02.html

[Chris1201]

I could do that, but what would I use to define the current date?

[DonkeyOte]

see TODAY() function.

in context of CF see: http://www.contextures.com/xlCondFormat03.html#Expiry

[contaminated]

but what would I use to define the current date?

With TODAY() function...