+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting range changing depending on selection

  1. #1
    Forum Contributor
    Join Date
    06-15-2011
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    117

    Conditional formatting range changing depending on selection

    When this macro runs, the area that the CF applies to changes depending on which cell is selected:

    Please Login or Register  to view this content.
    How do I stop it doing that? I could just select the correct cell, but is there a better way?

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    06-15-2011
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    117

    Re: Conditional formatting range changing depending on selection

    Realised it is reading the formula as a relative reference:

    Formula1:="=RC[1]=TRUE"
    Last edited by tone640; 05-30-2012 at 07:08 AM.

+ 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