+ Reply to Thread
Results 1 to 5 of 5

color cell based on percentage

Hybrid View

mangeshp4 color cell based on percentage 11-17-2010, 05:53 AM
Domski Re: color cell based on... 11-17-2010, 05:58 AM
mangeshp4 Re: color cell based on... 11-17-2010, 06:21 AM
Domski Re: color cell based on... 11-17-2010, 07:06 AM
arthurbr Re: color cell based on... 11-17-2010, 06:23 AM
  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    INDIA
    MS-Off Ver
    EXCEL 2010
    Posts
    53

    color cell based on percentage

    Hi

    I am having 2 value like target & % is coplete.
    Can i color a cell bases on % complete.

    say target is 100% so cell background color will be BLACK... & if 40% completed then same cell should be devided 40% as RED background & 60% BLACK background.

    Thanks.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: color cell based on percentage

    You can't partially fill the background colour of a cell like that I'm afraid.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    INDIA
    MS-Off Ver
    EXCEL 2010
    Posts
    53

    Re: color cell based on percentage

    ok can it be filled 40% rest can be blank...........

  4. #4
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: color cell based on percentage

    One thing you might want to look at is simulated in cell charting similar to Sparklines that were introduced in Excel 2010.

    I've attached an example.

    Dom
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: color cell based on percentage

    No can do I'm afraid - As Domski stated

+ 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