Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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 -- Al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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 "gramps" wrote: 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 -- Al |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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 -- Al "daddylonglegs" wrote: 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 "gramps" wrote: 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 -- Al |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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.....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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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 -- Al "daddylonglegs" wrote: 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 "gramps" wrote: 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 -- Al |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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. -- Al "David McRitchie" wrote: 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.....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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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 -- Al "daddylonglegs" wrote: 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 "gramps" wrote: 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 -- Al |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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. -- Al "David McRitchie" wrote: 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.....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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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 -- Al "daddylonglegs" wrote: 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 "gramps" wrote: 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 -- Al |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't use Conditional formatting
Many Thanx again you have solved my problem perfectly.
-- Al "David McRitchie" wrote: 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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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. -- Al "David McRitchie" wrote: 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.....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 --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gramps" wrote in message ... 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 -- Al "daddylonglegs" wrote: 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 "gramps" wrote: 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 -- Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |