+ Reply to Thread
Results 1 to 7 of 7

Change the Back Ground Color on basis of content of cell in a range

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Change the Back Ground Color on basis of content of cell in a range

    Hi Guys

    I do need your help regarding one of my projects in this i had to change the color of cell to yellow if the cell content is "N/A"

    i had write few lines but don't know how to move in a range cell by cell
    plz help me with this

    Please Login or Register  to view this content.

    in this cell should be defined as which type?

    and if u modify this code i'd be really gr8ful
    Last edited by ravinder_tigh; 06-01-2009 at 11:24 PM.
    Thanks & Regards
    Ravinder S
    (Ravinder_tigh)

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Change the Back Ground Color on basis of content of cell in a range

    Hi Ravinder
    try something like
    Please Login or Register  to view this content.
    But better still why not use conditional formating??
    Last edited by pike; 06-01-2009 at 05:46 AM. Reason: correction

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Change the Back Ground Color on basis of content of cell in a range

    Why use VBa, that's what conditional Formatting does

    http://www.excel-it.com/excel_condit...formatting.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Change the Back Ground Color on basis of content of cell in a range

    i have to apply this code on multiple sheets of multiple workbooks that's y couldn't use cond. formatting i'm still a bit confuse what should be the data type for cell is it string or range

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Change the Back Ground Color on basis of content of cell in a range

    Ravinder
    cell as range

  6. #6
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Change the Back Ground Color on basis of content of cell in a range

    thanks a lot the same i did jst want to confirm
    thanks a million

    Regards,

    Ravinder S

  7. #7
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Change the Back Ground Color on basis of content of cell in a range

    Quote Originally Posted by ravinder_tigh View Post
    thanks a lot the same i did jst want to confirm
    thanks a million

    Regards,

    Ravinder S
    no problem, its allway good to confirm

    how about running code to conditional format it will be quicker that a loop

    some thing like
    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)

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