Results 1 to 5 of 5

Thread: Format help

  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Format help

    hi all,
    i need help to get the format as per the conditions specified in the attached file.
    Attached Files Attached Files
    Last edited by dubdub; 2015-03-31 at 21:29.
    TIA
    dubdub

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Conditional formatting with two conditions/formulas after selecting the full range:

    (a) =AND(G9<=10%,G9<>0)
    (b) =G9>=10%

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    thank you Kweaver for your quick response, but the format should be based on the difference between 2015 and 2014. for example for JAN the 2015 value is 2% while 2014 value is 12% the delta of 2015-2014 is -10, under this scenario it will have the indicated format, basically, the formula has to consider the delta or the 2015-2014 result and based the result the format will be executed and formated as indicated.
    TIA
    dubdub

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    From your example attached, I thought you wanted G9 to S9 to be filled with a color depending on the value in THOSE CELLS. So, do you mean

    the green: =AND((G8-G9)<=10%,(G8-G9)<>0)
    the red: =(G8-G9)>=10%

    Of course, if the subtraction should be the reverse, just switch the cell references.
    Again, this is in conditional formatting with the range of cells in row 9 selected.

    Try the attached.
    Attached Files Attached Files
    Last edited by kweaver; 2015-04-01 at 13:18. Reason: Removed cols per instructions from OP

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Great thanks Kweaver for the help.
    TIA
    dubdub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •