Excel Conditional Formatting add-in

  cedricthecat 10:48 17 May 2007
Locked

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?!

Thanks!

  johnnyrocker 10:51 17 May 2007

can you not use the "if" formula?



johnny.

  cedricthecat 11:02 17 May 2007

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

[Red][=1]0;[Blue][=2]0;[Green]0

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 2007

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires