| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51063 | 2004-11-10 11:51:00 | excel macro | bpt1 (419) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 290184 | 2004-11-10 11:51:00 | 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 |
bpt1 (419) | ||
| 290185 | 2004-11-10 13:52:00 | 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. | Big John (551) | ||
| 290186 | 2004-11-10 19:56:00 | Thanks These are the tips I like so much about PressF1 |
Woof (2402) | ||
| 290187 | 2004-11-11 10:21:00 | And I was hoping to learn something really clever! But thanks! bpt1 |
bpt1 (419) | ||
| 290188 | 2004-11-11 10:28:00 | Are any of you members at Mr Excel (www.mrexcel.com)? 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 | andrew93 (249) | ||
| 1 | |||||