+ Reply to Thread
Results 1 to 4 of 4

Condition Formatting Formula

  1. #1
    Forum Contributor
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    104

    Condition Formatting Formula

    While I am good with excel formulas, I am no good with conditional formatting formulas.
    What I am trying to accomplish is a CF formula that check if the ABS(value) in columns D & E meets 2 criteria:
    >= B41 AND >= B42

    I have posted a sample workbook.

    Any help or guidance is appreciated,
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Condition Formatting Formula

    Perhaps this?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Forum Contributor
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    104

    Re: Condition Formatting Formula

    That be it!
    Is there a way to highlight the full line?

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Condition Formatting Formula

    If you select all the data in the table, starting at A2 and ending at the bottom right and THEN apply the CF formula in post#2 then it'll highlight the full line.

    See attached.

    BSB
    Attached Files Attached Files

+ 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. Need a formula to use condition formatting?
    By Mr.Castle in forum Excel General
    Replies: 5
    Last Post: 06-12-2019, 04:02 PM
  2. Condition formatting formula 10% above average of selected row
    By Kresho S. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-02-2015, 09:27 PM
  3. Replies: 6
    Last Post: 02-26-2015, 10:35 PM
  4. [SOLVED] How to use conditional formatting formula to add border when condition met
    By arisphaedrus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2014, 09:44 AM
  5. Condition Formatting with Formula
    By robbie010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2014, 09:07 AM
  6. Conditional Formatting with condition formula
    By coolzero in forum Excel General
    Replies: 4
    Last Post: 03-17-2010, 04:23 PM
  7. Condition Formatting - Viewing CF formula at each cell
    By rwgrietveld in forum Excel General
    Replies: 4
    Last Post: 01-06-2010, 03:33 PM

Tags for this Thread

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