Excel Conditional Formatting add-in

  cedricthecat 10:48 17 May 07

Struggling in Excel as I need to use moer than 3 conditionals....

I've heard that there's an add-in

Can anyone advise on where to find it and if it's any good?!


  johnnyrocker 10:51 17 May 07

can you not use the "if" formula?


  cedricthecat 11:02 17 May 07

Sorry, I should have made my needs clearer!

I have one column with a value taken from another column, which will show numbers 1, 2, 3, 4 or 5

I've managed to get these to show in 5 different colours (red, blue, green, yellow, orange)using the format workaround of


with Conditional Formatting to change to blue font for 2, green font for 3 and yellow for 4

Problem is, I want another column to work as a visual representation of these colours only and this has no data in it.

I thought of copying the data from the first column, and hiding it using the ;;; custom format, but this wouldn't work, as the workaround only allows 5 font colours!

Vog has come up with a way of using VBA to take the font colour of the one column to colour the background of the other, but this only works on the initial font, not the "conditioned" one!

  VoG II 11:27 17 May 07

Try click here or upgrade to Excel 2007 - the number of CFs is limited only by system memory.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…