sms 15:41 22 Mar 05

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 05

You could do it using VBA...

  VoG II 17:03 22 Mar 05

Look at Conditional Formatting in Help.

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

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

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

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…