+ Reply to Thread
Results 1 to 4 of 4

Using conditional formatting to recognize values in two columns to highlight a row

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Modesto, California
    MS-Off Ver
    Excel:Mac 2008
    Posts
    4

    Using conditional formatting to recognize values in two columns to highlight a row

    Hi There!

    I've been coming to this site for some time now to get advice on various functions within excel, and I thank everyone of you for your knowledge and willingness to help since. I have learned so much because of all of you. But for the first time, I cannot find this specific problem. I believe it is because the excel that this office utilizes uses conditional formatting in a different manner than previous versions. Or perhaps its a mac version.

    Anyway, here is the problem I am having.

    My version of Excel is Excel:Mac 2008. (not my choice)

    I am trying to highlight a row of cells when 2 conditions are met. The first condition that I need to be met is a cell in the row I want highlighted with a one of two words entered. The second condition is a separate cell in the same row that is 40 days past the date entered.

    IE:

    When, lets say, Apple in the first cell is entered and the date entered in the second cell is 40 days or more past, the row both cells are in will change colors. OR When, lets say, Orange in the first cell is entered and the date in the second cell is 40 days or more past.

    I have been able to do this using my Excel at home (PC version of Excel 2007), however it is my understanding that Excel:Mac 2008 doesn't use "rules", or just uses some variation of them, causing the condition not to function.
    Last edited by benslaw; 11-20-2012 at 08:22 PM.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Using conditional formatting to recognize values in two columns to highlight a row

    Conditional Formatting formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Highlight the rows you want affected, and change the matched cells to the cells your values are in.

    - Moo

  3. #3
    Registered User
    Join Date
    11-20-2012
    Location
    Modesto, California
    MS-Off Ver
    Excel:Mac 2008
    Posts
    4

    Re: Using conditional formatting to recognize values in two columns to highlight a row

    Well, I see where I went wrong, thanks for the quick reply Moo.

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Using conditional formatting to recognize values in two columns to highlight a row

    You're welcome. Glad I could help

    - Moo

    - - - - - - - - - -
    If you are satisfied with the solution(s) provided, please mark the thread as [SOLVED] by clicking on the words 'Thread Tools' above your 1st post in this thread. Then select 'Mark Thread as Solved'.

    Also, a good way to 'Say thanks' to those who have helped is to click on the star below their name in one of their posts. It's always appreciated.

+ 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