+ Reply to Thread
Results 1 to 11 of 11

Top/Bottom Rule for Conditional formatting

Hybrid View

  1. #1
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Top/Bottom Rule for Conditional formatting

    Try

    =C2<=SMALL(IF($B$2:$B$6="x",$C$2:$C$6),$F$1)

    EFthequebs.xlsx

  2. #2
    Registered User
    Join Date
    10-13-2013
    Location
    TX
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Top/Bottom Rule for Conditional formatting

    I guess I'm not explaining what I need very well. I want the 2 (from F1) people with the lowest hours (from column C) who signed up (from column B) for overtime to be highlighted. So.... They have to have an X next to their name in column B AND have the lowest hours in column C. In my original example sheet it is highlighted how it SHOULD look if it were working the way I need it to.

+ 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. Toggle one conditional formatting rule on off using VB
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 10:56 AM
  2. [SOLVED] conditional formatting new rule formula
    By wannabe_guru in forum Excel General
    Replies: 4
    Last Post: 05-01-2012, 11:56 AM
  3. Conditional formatting rule need help
    By Kagesen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2011, 04:42 AM
  4. Replies: 1
    Last Post: 07-29-2010, 11:26 AM
  5. Excel 2007 : Conditional Formatting Percent rule
    By Ichigo in forum Excel General
    Replies: 1
    Last Post: 04-25-2009, 12:50 AM

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