+ Reply to Thread
Results 1 to 13 of 13

Conditional formatting based on rows AND columns

Hybrid View

  1. #1
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,725

    Re: Conditional formatting based on rows AND columns

    This is simpler than my previous in post #6 and no longer requires helper columns or lookup table.

    In the Name Manager Full_Part formula try
    Formula: copy to clipboard
    =SUMPRODUCT((Sheet1!$A2=Sheet1!$A$2:$A$10)*(Sheet1!C$2:C$10={"Full time","Part time"})*{1,0.75})
    The CF formulas remain the same as before.
    Dave

  2. #2
    Registered User
    Join Date
    10-04-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Conditional formatting based on rows AND columns

    Thanks to both of you!

    Using your input I solved it with
    OR(COUNTIFS(Person;$A2;C:C;"Full time")>1;COUNTIFS(Person;$A2;C:C;"Part time")>2)
    for red formatting.
    The rule applies to range $C$2:$E:$100.
    Stop if true is checked.
    Green formatting is a lot easier with a rule of just "Cell contains" "Full time" or "Part time".

    My only remaining problem is that my sheet has become very slow in responding so I am considering a macro, but that should be posted elsewhere, unless anyone here has any tips on speeding it up.
    Thanks again,
    /Helena

+ 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. Replies: 1
    Last Post: 05-23-2016, 01:53 PM
  2. Conditional Formatting based on few columns
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2014, 04:11 AM
  3. [SOLVED] Conditional Formatting: Duplicate rows based on multiple columns.
    By Old4xford in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2014, 11:25 AM
  4. Flip Rows and Columns and Conditional Formatting - Please Help
    By tracy702 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-09-2013, 08:54 AM
  5. Conditional Formatting - Multiple Rows and Columns
    By mltucc in forum Excel General
    Replies: 2
    Last Post: 04-20-2012, 10:30 PM
  6. Conditional Formatting - Multiple rows/columns
    By Phillydog in forum Excel General
    Replies: 4
    Last Post: 03-21-2011, 04:50 PM
  7. concatenate rows with columns based on conditional formatting in VBA?
    By bandit_kaine in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2010, 03:16 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