Excel. More than three items in conditional forma

  linden 22:54 13 Jul 05
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 05

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 05

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 05

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 05

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

  linden 18:40 26 Sep 05

It worked perfectly - sorry I forgot to click resolved!

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…