I am working on a spreadsheet in excel 2003. I have a column of dates and I
want to format each month to have a different color. Under format,
conditional formatting is in gray and won't allow me to select it. Does
anyone know what I'm doing wrong?

You may be in "Edit mode" with your cell selection..........click off your
selected cell(s) and then try highlighting them again.........

Vaya con Dios,
Chuck, CABGx3


"dgams" wrote in message
...
I am working on a spreadsheet in excel 2003. I have a column of dates and
I
want to format each month to have a different color. Under format,
conditional formatting is in gray and won't allow me to select it. Does
anyone know what I'm doing wrong?

You probably have protected the worksheet, another possibility is
sharing. I have a page on grayed out things.
http://www.mvps.org/dmcritchie/excel/grayedout.htm

Unprotect the worksheet, change your conditional formatting and
turn protection back on -- it that was the problem.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dgams" wrote...
I am working on a spreadsheet in excel 2003. I have a column of dates and I
want to format each month to have a different color. Under format,
conditional formatting is in gray and won't allow me to select it. Does
anyone know what I'm doing wrong?

Is the worksheet protection enabled?

Is the workbook shared?

Either of these will gray out the CF function.


Gord Dibben Excel MVP

On Sat, 23 Apr 2005 07:35:01 -0700, "dgams"
wrote:

I am working on a spreadsheet in excel 2003. I have a column of dates and I
want to format each month to have a different color. Under format,
conditional formatting is in gray and won't allow me to select it. Does
anyone know what I'm doing wrong?