Results 1 to 5 of 5

Thread: excel macro

  1. #1
    bpt1
    Guest

    Default excel macro

    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

  2. #2
    Big John
    Guest

    Default Re: excel macro

    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.

  3. #3
    Woof
    Guest

    Default Re: excel macro

    Thanks

    These are the tips I like so much about PressF1

  4. #4
    bpt1
    Guest

    Default Re: excel macro

    And I was hoping to learn something really clever! But thanks!

    bpt1

  5. #5
    andrew93
    Guest

    Default Re: excel macro

    Are any of you members at Mr Excel? 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)

Similar Threads

  1. Excel Macro
    By GrahamB in forum PressF1
    Replies: 3
    Last Post: 09-05-2008, 03:37 PM
  2. Macro Excel
    By BoutFam in forum PressF1
    Replies: 4
    Last Post: 12-11-2005, 08:39 AM
  3. Excel Macro
    By in forum PressF1
    Replies: 1
    Last Post: 11-09-2001, 01:03 PM
  4. excel macro
    By in forum PressF1
    Replies: 2
    Last Post: 19-02-2001, 08:32 PM
  5. Excel macro
    By in forum PressF1
    Replies: 0
    Last Post: 06-09-2000, 04:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •