+ Reply to Thread
Results 1 to 2 of 2

Apply Conditional Formatting to Relative Range

  1. #1
    Registered User
    Join Date
    06-03-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    20

    Apply Conditional Formatting to Relative Range

    Hello,

    I have applied conditional formatting to a group of cells A1:C3 based on the value of A1, so that if A1 = x then A1:C3 is highlighted. However I need to repeat this group of 9 cells multiple times down the spreadsheet; for example, I need A4:C6 to be the same, A7:C9, etc. The condition formula uses relative references (so that when I copy the group and paste, the condition is A4 = x, A7 = x, etc.). However I can't seem to get the "Applies to" range to stay relative. When I copy A1:C3 down, the new CF rule evaluates A4 as it should but still applies the format to A1:C3 and not A4:C6. Is there any way to make the "Applies to" relative, or do I actually have to manually change the range for each group?

    Thank you!

  2. #2
    Registered User
    Join Date
    04-07-2014
    Location
    Port Talbot, Wales
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Apply Conditional Formatting to Relative Range

    Try removing the $ signs in the cell references when applying the conditional formatting
    Cobwebs, Alba Gu Brath (Scotland Forever)

+ 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. Conditional formatting if in range of values: apply to column
    By marcopietro in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2014, 02:34 PM
  2. [SOLVED] Macro to apply Conditional Formatting to a range in every worksheet
    By Floydlevedale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2013, 01:53 AM
  3. [SOLVED] Conditional Formatting Apply to Range
    By daved2424 in forum Excel General
    Replies: 3
    Last Post: 09-27-2012, 08:35 AM
  4. [SOLVED] How to apply Conditional Formatting to just ONE cell and NOT its duplicates in a range?
    By otorrhea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2012, 02:31 AM
  5. Conditional Formatting won't apply to Entire Range
    By DoriBeE in forum Excel General
    Replies: 8
    Last Post: 05-11-2011, 03:55 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