conditional formatting limitation

R

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
 
N

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.
 
R

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
 
Top