+ Reply to Thread
Results 1 to 2 of 2

Applying conditional formatting between two percentage columns

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    0

    Applying conditional formatting between two percentage columns

    Hello,

    I am trying to create a conditional format on a cell that contains percentages.
    For example:
    Cell D2= 8.0% but actually 7.998% if the decimals are increased
    cell D3 = 8.0% but actually 7.997% if the decimals are increased

    What i have done is add a conditional format to cell D3- Red if it is higher, Orange if it is the same and green if it is lower.

    However as the numbers are slightly different it is highlighting it either red or green, when in actual fact the number is so minimal in difference.

    I added the "round formula" which worked, however this only works if the numbers are the same as the above. But if it is a bigger difference e.g 8.25 vs 8.95 then the "round" format should not be applied.

    I want to be able to use the same format on all cells rather than adding a different formula to each one.

    thanks

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello reenap,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] Conditional Formatting not applying
    By Lovelylou79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2013, 11:01 PM
  2. Conditional formatting on non-empty cells - VBA
    By kotonikak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 02:57 PM
  3. Applying Conditional Formatting to an Entire Row
    By ltmaiyk in forum Excel General
    Replies: 4
    Last Post: 02-19-2010, 01:46 PM
  4. Applying Conditional Formatting to Multiple Rows
    By dcaldwell86 in forum Excel General
    Replies: 1
    Last Post: 10-02-2009, 09:32 AM
  5. Applying conditional formatting to ODD rows
    By SirSFZ in forum Excel General
    Replies: 0
    Last Post: 03-31-2005, 10:46 AM

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