+ Reply to Thread
Results 1 to 5 of 5

Make cell red when value is X in a matrix

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Make cell red when value is X in a matrix

    I want cel AR23 to be red when its orange and has a value in it. I made it for AK23 with TRUE and UNTRUE, and I think that was the best way, is there a way to do this for AR23 with a macro or something? To find number 11 in the table and then just the part ' Ramon' only on the left corresponding with the date, I think it should be like that. I tried to do the same as in AR23, but its kinda hard. Someone a solution? Thanks!
    1234.xlsm

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Make cell red when value is X in a matrix

    I want cel AR23 to be red when its orange and has a value in it.
    you could add another conditional format
    so that
    =IF(AND(D39=11,AR23>0) TRUE,FALSE)
    depends what you mean by a value in it
    or
    =IF(AND(D39=11,AR23<>"") TRUE,FALSE)
    Last edited by etaf; 02-25-2013 at 02:04 PM.

  3. #3
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Make cell red when value is X in a matrix

    Oh wow thanks, and how do I change the formule for more conditions, so D39=11 and AR>0 and D39=10 and AR>0 so both in your formula? Something with the OR formula aswell right?
    =IF(OR(D39=11,D39=10,AR23>0) TRUE,FALSE) this one gets red if it meets one of those 3 criteria, but I want it to meet the 2 I just mentioned.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Make cell red when value is X in a matrix

    D39=11 and AR>0

    D39=10 and AR>0

    =AND(OR(D39=10,D39=10), AR>0)

  5. #5
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Make cell red when value is X in a matrix

    Cool that worked thanks!

+ 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