Results 1 to 4 of 4

create a simple macro that changes fill color

Threaded View

Niclas create a simple macro that... 02-17-2008, 10:19 AM
Bjornar You don't need a macro for... 02-17-2008, 11:08 AM
Richard Buttrey Hi, You don't really need... 02-17-2008, 11:22 AM
Niclas Thanks guys! Will try this... 02-17-2008, 05:13 PM
  1. 02-17-2008, 10:19 AM #1
    Niclas is offline
    Registered User
    Join Date
    02-08-2008
    Posts
    2

    create a simple macro that changes fill color

    Hi guys! Found this forum today, it looks good!

    It's been a while ago since I've been working with excel, and I forgot alot of things. I really need help creating a macro that changes the fill color of a cell depending on the value in another cell.

    I have 3 rows. 1 is ID number, could be anything. 2 is Value A and 3 is Value B.

    I have 4 ranges that I need to use.
    Range 1: AWAY (FILL WITH BLUE)
    Range 2: 0 to -99999 (FILL WITH RED)
    Range 3: 30 to 0 (FILL WITH YELLOW)
    Range 4: 30 to 99999 (FILL WITH GREEN)


    Range 1 is priority ONE and so on. So if VALUE A = 40 and VALUE B = -10, then the FILL COLOR inn ROW 1 = RED.



    Sorry for my bad english, but I'll hope you understand what I want. I attached a copy of my .xls.


    Regards,
    Niclas
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1