One way
Select the whole range, do formatconditional formatting
select formula is and type

=DATE(YEAR($A2),MONTH($A2),1)<DATE(YEAR(TODAY()),M ONTH(TODAY()),1)

click the format button, select font and select a grey colour, click OK
twice

Replace A2 with the first cell with a date in your selected range, so if you
select from C4 to F100 and C4 is the active cell use C4


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"Freshman" wrote in message
...
Dear experts,

I've a table with 5 columns. The first column is for "Date" (e.g. 15 Jun
07). Each row is a record. My question is, if the rows of records are not
belonged to current months, i.e. belonged to previous months, I want those
rows of records' text colour automatically changed to gray colour. Please
advise how to do this if it is possible.

Thanks in advance.