+ Reply to Thread
Results 1 to 10 of 10

Number change color depend if left cell turn yellow

  1. #1
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Number change color depend if left cell turn yellow

    Hi to all

    I've been searching for colorfuntion or colorfont in this site and Google for my likeness but have not luck.

    I have to create a spreadsheet for others who dont know much about Excel.

    Numbers in E column is to change color if B column in same row turn yellow.

    There are number 1 to 5 in E column

    Like number 5 in Column E turn blue if cell in B column in same row turn yellow
    and number 4 in Column E turn green and number 3 in Column E turn pink and so on.

    I tried this code but have no luck

    Please Login or Register  to view this content.

    I attached sample book for you to see

    NumberChangeColor2.xlsm
    Last edited by unley; 06-01-2011 at 02:40 AM.
    I'm using MS Office 2013

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Number change color depend if left cell turn yellow

    Hi unley,

    change your if statements to:
    Please Login or Register  to view this content.
    Last edited by Mordred; 06-01-2011 at 01:52 AM.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Number change color depend if left cell turn yellow

    I've altered your code for you in you example workbook.

    Regards:
    Attached Files Attached Files

  4. #4
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Number change color depend if left cell turn yellow

    thank you very much for this Mordred

    I changed to font instead of interior but the rest did not work. I wonder why.

    Should not make any different with font or interior


    Copy of NumberChangeColor2.xlsm

  5. #5
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Number change color depend if left cell turn yellow

    Try:
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Number change color depend if left cell turn yellow

    Thank you again for this, just a simple work swap there hehe but row 4 to 6 only work but the rest of the rows not working

    Copy of NumberChangeColor2.xlsm

  7. #7
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Number change color depend if left cell turn yellow

    Oh it work mate but very slow reaction. It only work when you click on the same numbers again. If you input yellow interior in B Columns nothing happen unless you have to click on the same numbers again in E Columns to make the font change color.

    Normally, the fellas fill in cell with yellow so the numbers should change automatically
    Last edited by unley; 06-01-2011 at 02:23 AM.

  8. #8
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Number change color depend if left cell turn yellow

    It will only make a change if a cell in column B is yellow AND if the cells in Column E meet the criteria outlined by you. If your criteria is one OR the other, you'll have to change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Number change color depend if left cell turn yellow

    Thank Mordred but I prefer your code the one before because wth to 'Or' instead of 'And' the numbers in Column B change with or without column B fill in yellow lol

    So thank you Mordred for your time

  10. #10
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Number change color depend if left cell turn yellow

    You are most welcome unley.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1