Results 1 to 18 of 18

Conditional Formatting cells in a large grid....

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Conditional Formatting cells in a large grid....

    Hi

    I have the attached spreadsheet which makes the question easier to understand. Basically when you read across and down rows and columns, I'd like the intersecting cell to turn red if the horizontal and vertical row columns letters are different. So in the attached B5 is red because B1=A and A5 is B. Where the intersecting cells match in values, the cells will stay white.

    I can create a formula to conditionally format one cell to red: =A2<>B1

    but i have a large grid and it would mean re-creating each formula for each cell. Any idea on how to expand it to the whole range?
    Attached Files Attached Files
    Last edited by Barking_Mad; 06-26-2013 at 10:46 AM.

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