software

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.


Hello Heatherz70,

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

Sincerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=506267CF 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)

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