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.

Gray Out Expired Records
 

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.

Gray Out Expired Records
 

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.

Gray Out Expired Records
 

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.

Gray Out Expired Records
 

Hi Peo,

Thanks for your help. Regards.

"Peo Sjoblom" wrote:

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.

Gray Out Expired Records
 

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.