+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting

  1. #1
    Registered User
    Join Date
    05-09-2010
    Location
    Belgrade,Serbia
    MS-Off Ver
    Excel 2013
    Posts
    33

    Conditional formatting

    Hi,

    I'm comparing data from two columns using "data bars".The problem is that what i see does not reflect the reallity,f.e. comparing 6 and 4 resulting in the same bar width as with 9 and 1.To solve this i'm seting the values myself,the shortest bar to 0 and the longest to 10 and it works fine that way.But it's almost impossible to do it manually with over 100 records.
    Maybe i'm overlooking some simple option which could resolve this?

    And the second thing that bothers me concerned data bars as well.Is there any option that could change the bars' colour based on the cell value?In above example if cell value is 1-4 then bar would turn red,5-7 blue and so on...Is it possible in excel 2007?

    Any help will be greatly appreciated.
    Last edited by Stefan22; 05-22-2010 at 08:48 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,052

    Re: Conditional formatting

    Please take a moment and read the forum rules.

    cross posted http://www.mrexcel.com/forum/showthread.php?t=469893

  3. #3
    Registered User
    Join Date
    05-09-2010
    Location
    Belgrade,Serbia
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Conditional formatting

    Sorry,not used to read it.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,052

    Re: Conditional formatting

    Forum Rules

    Looks like you are getting some help over at MrExcel

  5. #5
    Registered User
    Join Date
    05-09-2010
    Location
    Belgrade,Serbia
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Conditional formatting

    Actually its solved now.

    With A7:B11 range formula for the longest bar should be =MAX(($A$7:$A$11)+($B$7:$B$11)) and the shortest bar is always set to 0.

    As far as the second part of my question is concerned here's the link for that http://blogs.msdn.com/excel/archive/...24/538875.aspx

    Sorry for misunderstanding,

    Best regards.

+ 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