Excel. More than three items in conditional forma

  linden 22:54 13 Jul 2005
Locked

I have five items in a column in Excel. I would like each to have a different conditional format. Excel seems to only allow three. Anyone know how to get more?

Linden

  daba 01:16 14 Jul 2005

Can be done with vba - no doubt, but I'd have to play about with it for a while to get the results you need

I'll bump this for VoG, he'll sort it in a jiffy !

  VoG II 06:15 14 Jul 2005

You can actually get 4 if you count the default condition as one of them. If you need more then you need to use some code. Here is an example click here

  linden 08:26 14 Jul 2005

Thank you Vog

Followed the link. More than time I got into code - so thanks for the signpost!! I will have a go this weekend but looks good. For interest I need about seven, All numbers - as people type in the number I want it to be a different colour. The code looks likely to solve it . Will report back later.


Linden

  daba 21:30 14 Jul 2005

"..can get 4.." lateral thinking VoG, I like it !!

  linden 18:40 26 Sep 2005

It worked perfectly - sorry I forgot to click resolved!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)