multiple colors for one cell

H

heatherz70

Is there a way to have more than one color choice for a cell. I am making a
schedule and I would like to be able to assign 4 different color choices to
each cell for different things? I also am using an older excel..2000 I
believe.
 
L

Leith Ross

Hello Heatherz70,

Conditional formatting has a limit of 3 colors per cell. Since you nee
4 colors, it will require writting a custom macro or User Define
Function (UDF). To do that would require more information about whic
color is generated by which condition and the layout of data on you
worksheet.

Sincerely,
Leith Ros
 
B

Bob Phillips

CF can be duped into 4 colours by setting all the cells to a default colour,
and then set condition formatting for the other 3 colours

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top