+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Issue

  1. #1
    Registered User
    Join Date
    05-02-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    15

    Conditional Formatting Issue

    I am attempting to get excel to highlight a row based on the result of a specific column.

    Excel Issue - Conditional Formating.JPG

    D Column Formula: =C2/$C$13

    F Column Formula: =E3/$E$13

    G Column Formula: =IF(D2,(F2-D2)/D2,0)

    H Column Formula: =IF(B2,((E2*24)-B2)/B2,0)

    Columns B, C & E are manual entry fields.

    Formatting Rule for Column G & H: Green Up Arrow when value is > = 0.01; Yellow Dash when value is = 0; Red Down Arrow when value is < 0

    How do I set up the conditional formating so that the row will be highlited a color when the total in Column H is > than the total in Column B?

    Thank you in advance for your help!!!

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Conditional Formatting Issue

    Do you have sample spreadsheet for this ?

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    on the conditional formatting formula

    And on the section APPLIES TO

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by saravnepali; 11-24-2019 at 04:29 PM.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

+ 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 issue
    By whahnelt in forum Excel General
    Replies: 2
    Last Post: 10-07-2019, 05:07 AM
  2. Conditional formatting issue
    By Stief1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2019, 10:36 AM
  3. Custom formatting issue using conditional formatting
    By wrongway15 in forum Excel General
    Replies: 2
    Last Post: 07-13-2014, 03:18 PM
  4. Conditional Formatting Issue
    By Caedmonball19 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-24-2013, 09:59 AM
  5. [SOLVED] Conditional Formatting Issue
    By nikolasm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-12-2013, 01:34 PM
  6. Excel 2007 : conditional formatting issue
    By RDOREMUS in forum Excel General
    Replies: 2
    Last Post: 03-30-2011, 11:01 AM
  7. Conditional formatting issue
    By Cramer19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2007, 01:29 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