Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

VB in Excel

Options
  • 09-03-2007 3:07pm
    #1
    Wanton
    Registered Users Posts: 585 ✭✭✭


    hi guys

    bit of help needed please.

    i have created an excel sheet to help me track my blood sugar levels (i am a diabetic)

    i have a few simple formulas the give me averages etc.

    what i am looking for is a macro or VB code of some sort that will automaticaly change the font colour of specific numbers.

    eg if the number is 1 to 4 then it would appear in blue, 4-8 black, 8-11 orange, 11+ red

    i have no idea around this kind of programming, so where normaly a push in the right direction would be nice i kind of need a fairly exact answer if at all possible.

    cheers

    wanton


Comments

  • Options
    #2
    NutJob
    Closed Accounts Posts: 884 ✭✭✭NutJob


    MENU ->format ->conditional formatting


    Bobs ur uncle and fanny's ur aunt


  • Options
    #3
    Wanton
    Registered Users Posts: 585 ✭✭✭Wanton


    bobs my uncle... .dont know about fanny, someone must not be telling me everything....

    THANKS FOR THE INFO!!!!


Advertisement