Can't use Conditional formatting

[Guest]

I have a cell in my worksheet that can have 4 alternative entries and I would
like each to be entered using a diferent font colour. Obviously I can't use
conditional formatting as you can only have up to 3 conditions. I have tried
using a lookup list but this only returns the correct entry but does not copy
the font colour.
An example of what I need is as follows:-
Entry Colour
"Rest" Red
"WRD" Green
"Sick" Blue
"Hols" Orange
Any suggestions as to a way round would be gratfully received

 

[Guest]

You can use conditional formatting if those are the only 4 possibilities.

Use a regular cell format to formatt all entries with red font for instance,
then use CF for the green, blue and orange options

 

[Guest]

Thanx for the quick response but unfortunately I didn't make it clear that
these 4 format colours are in addition to the standard font if none of the of
the other conditions apply so there is in fact a 5th choice of entry. Sorry
but my fault entirely.
Thanx again for your help

 

[David McRitchie]

It might look very busy, but if it is just for yourself it
then nobody else if involved, so it doesn't matter what
anyone else thinks. Here is an addin that will allow you
do what you ask.

xlDynamic.com : CFPlus Download
http://www.xldynamic.com/source/xld.CFPlus.Download.html

So if you are familiar with the way Conditional Formatting
works the above works or at least has a familiar user
interface.

My page on the regular Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[Guest]

David
Thanx for that it works a treat. However the downside is that my company IT
people won't let me put it on the company network so I can't actually share
the worksheet with my colleagues so unfortunately I cannot use this method.
Once again my thanx.

 

[David McRitchie]

I presume the restriction is on addins, and not on having macros.

Don't know if the value is calculated or manually entered, but
if manually entered you could use a Change Event macro
http://www.mvps.org/dmcritchie/excel/event.htm#case

 

[Guest]

Many Thanx again you have solved my problem perfectly.