+ Reply to Thread
Results 1 to 3 of 3

Highlight Cell value in color based on the input value in a another cell

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    38

    Highlight Cell value in color based on the input value in a another cell

    Hi Team,

    Need help on below :

    i have the data in one sheet starting from 1 to 90 and there is a input cell where i am passing a input value (should be between 1 to 90)

    now based on the value which i entered in the input cell (example : 35), then the corresponding cell value which has number 35 should be highlighted in some color (say Green in color)

    next time if i change the value in Input cell (example : 90) , then the color which was highlighted earlier for 35 should not be change the color from green to white, and the cell which has the number as 90 should be turned to Green in color.

    i have also attached the input data for the reference. can you please help me on this.

    Regards,
    Kamal M.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Highlight Cell value in color based on the input value in a another cell

    • Right-Click on the sheet tab
    • Select View Code from the pop-up context menu
    • Paste the code from below in the worksheet's code module


    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Highlight Cell value in color based on the input value in a another cell

    Try this:-
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to update cell value based on highlight color of other cell.
    By navbains in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2015, 05:14 PM
  2. Replies: 6
    Last Post: 10-23-2014, 04:48 PM
  3. VBA code to find the row number based on data via input box and the highlight a cell
    By Aditya Sabat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2014, 05:47 PM
  4. Based on Cell Color Input Value
    By sryadav12 in forum Excel General
    Replies: 2
    Last Post: 05-30-2014, 01:39 AM
  5. [SOLVED] Highlight row a certain color based on a character from a cell
    By ory182003 in forum Excel General
    Replies: 3
    Last Post: 05-11-2013, 06:15 PM
  6. Fill color columns based on Highlight Cell Rules
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2013, 09:34 AM
  7. Highlight Part Of Cell Based On Input
    By sysco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2006, 09:12 AM

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