Excel. More than three items in conditional forma

  linden 22:54 13 Jul 2005

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?


  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.


  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

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?