Results 1 to 7 of 7

IF/AND in Conditional Formatting

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-09-2009
    Location
    NJ/NY
    MS-Off Ver
    Excel 2007 & 2016
    Posts
    124

    IF/AND in Conditional Formatting

    Hi - for starters, I'm working with Excel 2007 with XP Pro...

    I'd like to use conditional formatting to highlight in bold red all of the cells in column A that exceed these two conditions:
    1) the cell value in column A is > 0.15, AND
    2) the cell value in column A is > than the value in the same row in column B; again, both of these conditions must be met.

    On the attached spreadsheet, I've demonstrated what I'd like to do. I've tried using the "Format only the cells that contain" Rule Type, but doing this produces many false positives. I think "Use a formula to determine which cells to format" with an IF/AND formula is what I need, but I haven't been able to figure out the correct syntax.

    Thanks very much.
    Attached Files Attached Files
    Last edited by OverKnight; 01-06-2012 at 04:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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