View Full Version : excel macro

10-11-2004, 11:51 PM
I am trying to write an excel macro such that when the number in a cell range is <4 the cell fill colour is green, when the value is between 4 and 7 the cell fill colour is orange and when the value is between 7 and 10 the cell fill colour is red. Any help with this?


Big John
11-11-2004, 01:52 AM
You don't need a macro to do this. Use conditional formating. It allows you to add up to 3 parameters and format the cell based on those. Very powerful tool. Find it under Format/Conditiona Formating. Select the cells you wish to affect first then use this menu.

11-11-2004, 07:56 AM

These are the tips I like so much about PressF1

11-11-2004, 10:21 PM
And I was hoping to learn something really clever! But thanks!


11-11-2004, 10:28 PM
Are any of you members at Mr Excel (http://www.mrexcel.com/board2/)? Now there's a really good Excel / Access site - the more you know the more you realise you don't know (plus it would be nice to have a few more knowledgeable Kiwis there) :D