Font color & Conditional Formatting limitations

[hmm]

I want the font color to be (automatically) different depending on the
month that is entered in the cell. How do I have more than 3 conditions
in a cell. (3 is the limit of conditions using Conditional Formatting).

thanks.

 

[Kieran]

This cannot be done without VBA using the Worksheet_change event.

Some background on this can be found a
http://www.cpearson.com/excel/events.htm.

Please give more specific details on the cell ranges and colours if yo
want a macro crafted for this

 

[hmm]

The cell range would be A1:A500. I just want to differentiate the months,
so I really only need 2 or 3 font colors - but each color would have to
apply to multiple months, which I don't believe is possible with
Conditional formatting.

 

[Mario León]

You can use formulas, type =Or(A1="Month1",A1="Month2",A2="Month3",...),
instead of the cell value and select the font color.
you can use the same for the other two conditions.
Is that what you are looking for?
Mario.

The cell range would be A1:A500. I just want to differentiate the months,
so I really only need 2 or 3 font colors - but each color would have to
apply to multiple months, which I don't believe is possible with
Conditional formatting.

 

[Kieran]

I thought you wanted 12 colours.

if you only need 4 then try the following conditional format.
Highlight a1:a500
Select format>conditional format
Select format 1
Select 'format is'
Enter formula =MOD(MONTH(A1),4)=0
Choose the colour
Choose add
Select format 2
Select 'format is'
Enter formula =MOD(MONTH(A1),3)=0
Choose a different colour
Choose add
Select format 3
Select 'format is'
Enter formula =MOD(MONTH(A1),2)=0
Choose a different colour
Press O

 

[hmm]

Thanks so much. I didn't think I could use multiple criteria in each condition.

One more question: Is there a way to copy these conditions to another range of
cells, so the color matches. I don't want to use the format painter because I
just want to change the conditional formatting, not the cell formatting, font
size, etc.

Thanks again.