PDA

View Full Version : excel macro



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

Thanks

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.

Woof
11-11-2004, 07:56 AM
Thanks

These are the tips I like so much about PressF1

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

bpt1

andrew93
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