+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting the value in Matrix

  1. #1
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Conditional formatting the value in Matrix

    Morning all,

    I have a matrix to display different items with a link to their file in each result. The row and column criteria are chosen from two list boxes above and I need to highlight the cell which displays the result of the details matched above.

    The linked cell for Fault list box is V15 and for ATM Type it's V20.

    I'm struggling simply because I think I'll need to use an array but I can't seem to ctrl+shift+enter this in conditional formatting.

    Thanks in advance
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Conditional formatting the value in Matrix

    Solved now with some playing around, using Excel hierarchy I placed the conditions in a new order to achieve what I wanted.

    Shown below in case this can help others
    Attached Images Attached Images

+ 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. [SOLVED] Risk Matrix Conditional Formatting
    By heepo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-22-2021, 09:12 PM
  2. Training Matrix - Conditional Formatting for dates occuring
    By Smannarn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2016, 11:37 AM
  3. [SOLVED] Conditional Formatting a Data Matrix
    By fearonc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2016, 03:48 PM
  4. Training matrix traffic lights conditional formatting
    By buju247 in forum Excel General
    Replies: 6
    Last Post: 11-29-2013, 05:44 AM
  5. Conditional Formatting Training Matrix Dates
    By hamiltg02 in forum Excel General
    Replies: 2
    Last Post: 05-01-2013, 05:49 PM
  6. [SOLVED] Automatic Conditional Formatting in matrix of information
    By Starkey in forum Excel General
    Replies: 5
    Last Post: 02-11-2013, 11:44 PM
  7. [SOLVED] Matrix formatting
    By Corey in forum Excel General
    Replies: 9
    Last Post: 01-23-2006, 02:25 PM

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