+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting with multiple conditions (Excel 2010)

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Santa Clarita, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Conditional Formatting with multiple conditions (Excel 2010)

    I'm trying to create a formula in excel that checks two separate columns before applying the color change to one of those columns. I see tutorials on how to do this in Excel 2007, but have yet to find an easy way of doing this in 2010.

    For an accurate example: In Column D we check "N" if someone is missing a specific document. In Column N of the same row, we specify what documents they are missing, but if nothing, we input "Complete".

    What I want to figure out how to do is: If Column D says "N" and Column N of the same row says "Complete", I want Column N to use the Light Red Fill with Dark Red Text.

    Can anyone help or direct me on how manually input this code in the future?
    Last edited by zyrakris; 01-16-2013 at 04:33 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    welcome to the forum

    It would be easier to help if you upload a sample workbook, but try this...
    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =and($D2="N",$N2="Complete")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    you could do this:
    Select column n, goto conditional formatting, new rule, use formula,
    =And(N1="Complete",D1="N")
    format,fill - light red,font -dark red,ok,ok

    not sure where CF is in 2010, but the formula should still work

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    @ FDibbins, sorry, your post wasn't up when I TRIED to post, then had spinning circle for minute or so...lol

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    @ Dredwolf, no problem, I have the same problem too

  6. #6
    Registered User
    Join Date
    01-15-2013
    Location
    Santa Clarita, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    Quote Originally Posted by dredwolf View Post
    you could do this:
    Select column n, goto conditional formatting, new rule, use formula,
    =And(N1="Complete",D1="N")
    format,fill - light red,font -dark red,ok,ok

    not sure where CF is in 2010, but the formula should still work

    Hope this helps
    This worked perfectly! Not sure why the other code didn't. Thank you both anyway!

  7. #7
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Conditional Formatting with multiple conditions (Excel 2010)

    You are welcome

    If you started your range at N1 and did not change the ranges in FDibbins' code to $D1..$N1 it would always be checking the NEXT row for the conditions, not the current row..
    the code is basically the same otherwise

+ Reply to Thread

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