+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional Formatting by row and column numerical labels

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    25

    Conditional Formatting by row and column numerical labels

    Hello,

    An array has its rows and columns marked 1-10. It shows probabilities of an occurrence specified for a row number, dependent on which column it crosses. However, for rows and columns marked with the same number it always shows 0.5, as it means probability of the occurrence when a row marker crosses "its own" column. The question: I don't know how to format the table conditionally so that it showed all "self-crossing" cells, that is row 1 vs column 1, row 2 vs column 2, etc. I have tried with INDEX, but to no avail. Could you help please? I don't want to format the cells by value but by coordinates, as I may happen to have some non-self-crossed 0.5s in the future, and I wouldn't want them formatted, for they'd obscure the view.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,662

    Re: Conditional Formatting by row and column numerical labels

    I labeled the top left cell of the table "TopLeft" then applied CF with:
    Please Login or Register  to view this content.
    to the table.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-27-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Conditional Formatting by row and column numerical labels

    Thanks a lot, that's what I needed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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