+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting: if value (x) is greater/less then value (y) then by %

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    MS Office 10
    Posts
    42

    Conditional Formatting: if value (x) is greater/less then value (y) then by %

    I have values in column A for my future forecast. In column B I have budget for that forecast. I have delta btw the two in Column C. I want to create a formula that will use conditional format preferably with icon sets instead of fill that will do the following:
    • If deviation exceeds in Column C + and – 10% or more has a red X or mark and anything within + and – 5% is ok.

    Could anyone please help? I would greatly appreciate it.

    Thank you.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Conditional Formatting: if value (x) is greater/less then value (y) then by %

    I don't think you can use icons for formula based on a rule. So column C has fill as a formatting.
    But you can create dummy column next to your column, write formula in it, format font white, and use icons in this column.
    Such approach is used in column D in attachment.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    MS Office 10
    Posts
    42

    Re: Conditional Formatting: if value (x) is greater/less then value (y) then by %

    Dziekuje Bardzo za pomoc.

+ 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. VBA Conditional Formatting (If cell value is greater than)
    By ahmedhammam29 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2016, 08:53 PM
  2. Conditional Formatting greater than 0 but not 0
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2016, 12:59 PM
  3. Excel 2007 : Conditional formatting-Value is greater than
    By satishtote123 in forum Excel General
    Replies: 1
    Last Post: 06-11-2011, 12:17 PM
  4. Conditional Formatting and Greater than BUT less than
    By dagindi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2010, 03:08 PM
  5. Conditional Formatting greater than 100%
    By henro8 in forum Excel General
    Replies: 5
    Last Post: 10-08-2008, 05:18 PM
  6. Conditional Formatting if greater than zero
    By jkpha in forum Excel General
    Replies: 2
    Last Post: 10-31-2007, 01:50 PM
  7. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 PM

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