+ Reply to Thread
Results 1 to 3 of 3

code for cell color change

  1. #1
    Registered User
    Join Date
    11-26-2020
    Location
    india
    MS-Off Ver
    2007
    Posts
    5

    code for cell color change

    Hi Team,

    I have a csv file and if status column value is met the cell color in excel should change in green color otherwise if status value is not met it should change in to red color.
    please help me can we do this in java or any other programming language

    Thanks in adv,

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: code for cell color change

    You need to be more clear and detailed on your request...

    you have a csv file, but you want excel cells to change color?
    what status? value? text? something else?

    I suggest that you upload a sample WB with examples of what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-26-2020
    Location
    india
    MS-Off Ver
    2007
    Posts
    5

    Re: code for cell color change

    Hi Ford,

    Thanks for your reply..

    I have csv file which having column like status if status="met" then the cell color sholud change to green in excel otherwise if status="not met" then cell color should change to red color.

    can we do this is java or any other programming languages
    if yes, how ?

    Thanks in adv,

+ 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. Need vba code to color cells and change color if not equal as text from cell
    By FvdF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2020, 08:45 AM
  2. [SOLVED] VB code to change font color of cell with criteria
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2018, 10:53 AM
  3. [SOLVED] Change cell color depending on cell color, error in code
    By mushedpotatos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2014, 04:20 AM
  4. Replies: 5
    Last Post: 12-07-2013, 02:21 PM
  5. [SOLVED] vba code to change the cell color by looking in a range that contains the color index valu
    By ckklconner in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2013, 09:15 AM
  6. Modify Code to change cell background color
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2008, 12:54 AM
  7. Change the interior color of a cell - Code Review
    By Tiny Tim in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2005, 05:55 PM

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