conditional formatting limitation

[rekoop]

Is there any way I can increase the limit of 3 when
conditional formatting? I am building a schedule and I
wish to colour code unique id's. The number of unique
id's exceeds three.

Thank-you

 

[Norman Harker]

Hi rekoop!

Apart from conditional formats and the default format you do have
ability to control font formats using the custom formats usually
reserved for positive, negative and zero.

See:
http://www.mcgimpsey.com/excel/conditional6.html


But in most cases where you need more than three formats for your
conditions, you will need to resort to VBA. For this, see:

Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/event.htm#case

However, if you are doing this for mainly presentation purposes, my
own view is that you should try to avoid too many different colours.

 

[rekoop]

Thanks,
I should have added that my numbers are in 11-111-11
format. I understand the method on at www.mcgimsey... is
for numbers (I had it working great for numbers) but is
there anyway make my number formatting work in custom
formats?
Sorry if I am missing something simple here.

Rekoop