Results 1 to 4 of 4

Excel 2007 : Conditional Formatting for Multiple Columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    Voorhees, NJ
    MS-Off Ver
    Excel 2007
    Posts
    4

    Conditional Formatting for Multiple Columns

    Good morning - I am stuck on trying to figure out how to conditionally format one column if two critera are met.

    I need to be able to highlight the entire row IF the sq ft % is 90% or greater AND the units column is 5 more units.

    Units Unit Sq Footage Sq Ft %
    5 425 92.6%
    1 100 90.0%
    3 375 95.8%
    7 800 92.8%

    I have been reviewing forums and can't find the formula that would fit correctly. I would appreciate any help that I can get on this. Thank you for reviewing.
    Attached Files Attached Files
    Last edited by NBVC; 10-18-2011 at 01: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