sms 15:41 22 Mar 2005

I have an excel spreadsheet and on it I have two boxes with ten cells per box.
I would like the boxes to show different colours for certain values. eg. if the value was 20 then 2 boxes would be filled with eg blue.
Could anyone advise how to do this

  Yoda Knight 15:52 22 Mar 2005

You could do it using VBA...

  VoG II 17:03 22 Mar 2005

Look at Conditional Formatting in Help.

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

6 great UX design talks you can watch online

How to jailbreak an iPhone or iPad in iOS 11 or iOS 10

Musique de Noël : les meilleures chansons en streaming