Loop counting and highlighting cells that are less than

[cnash52]

I have been asked to go through an extensive excel worksheet and count which dates are before a certain day and give my supervisor a total. There are thousands of dates. I know I can have excel do this for me I just don't remember how. I would like some help with the most basic VBA commands to do this. The values are in column K and each value has two blank rows under it before the next value. If I wanted to write script to go through the column and any value that is less than 20111230 in column K put a red X in the cell in the next column how would I go about doing it? Also, if I could have a counter so that I don't then have to go through and count the X's. I was thinking making a command button then at the end of the script having a msg box show up with the total dates less than the above date. This is an small example what the dates look like. I coule really use some help on this one.

20111002


20111203


20120523


20120523


20071104