+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Apply to Range

  1. #1
    Registered User
    Join Date
    03-20-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    7

    Conditional Formatting Apply to Range

    I want to set up a conditional formatting rule that is applied to all values of a range that are less than the maximum value within that range. I can get this to work if the range is fixed, but if I try and apply the rule to more cells it requires updating.

    Currently I have rule X where Cell Value is less than "=max($A$1:$A$10)" applied to range "$A$1:$A$10".

    What I want to do is change the range set in max to be all the cells to which the conditional formatting is set to run on so that as the rule is applied to more cells it changes the range in max.

    Does that make sense?

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Conditional Formatting Apply to Range

    If you want to include the entire Column A, try this:
    =MAX(A:A)
    Click on star (*) below if this helps

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,417

    Re: Conditional Formatting Apply to Range

    An alternative to shorten the range
    Please Login or Register  to view this content.
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  4. #4
    Registered User
    Join Date
    03-20-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Conditional Formatting Apply to Range

    That's great. Thank you.

+ 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