You're welcome!

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
Hi Biff,

Thanks for your help.

"T. Valko" wrote:

Try this:

Assume your data is in the range A1:E10
Select the range A1:E10
Goto the menu formatConditional formatting
Formula Is: =AND(ISNUMBER($A1),MONTH($A1)<MONTH(TODAY()))
Click the Format button
Goto the Patterns tab
Select a shade of gray
OK out

--
Biff
Microsoft Excel MVP


"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.