View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default Gray Out Expired Records

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.