+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting "Apply rule to.." Option not there

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    San Francisco
    MS-Off Ver
    2007
    Posts
    2

    Conditional Formatting "Apply rule to.." Option not there

    Hi all, I am trying to create a conditional formatting rule that expands as I add rows to my table. Online search has taught me about different options under "apply rule to.." that can help this, but this option is not appearing when I go to create/edit a rule.

    Also, the "Formatting options" button does NOT appear on the bottom right corner of my selection.


    Any help greatly appreciated!!
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Conditional Formatting "Apply rule to.." Option not there

    Your screenshot has the first option selected (Format all cells based on their values). The online example has the last row selected (Use a formula to determine which cells to format). Select the same row and you'll get the same options.

  3. #3
    Registered User
    Join Date
    08-05-2014
    Location
    San Francisco
    MS-Off Ver
    2007
    Posts
    2

    Re: Conditional Formatting "Apply rule to.." Option not there

    Thanks for your response! Unfortunately this was not the case (see attachment) excel help2.jpg

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Conditional Formatting "Apply rule to.." Option not there

    The initial rule you set will apply to whatever cells you have selected. After creating the rule, you can go into "Manage Rules" and you will see the box where it says "Apply rule to"

  5. #5
    Registered User
    Join Date
    07-19-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional Formatting "Apply rule to.." Option not there

    I know this is an old thread, but I am having the same issue. There is no "Apply rule to" option under Conditional Formatting. I can't find any solution anywhere online.

  6. #6
    Registered User
    Join Date
    07-19-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional Formatting "Apply rule to.." Option not there


+ 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. Replies: 6
    Last Post: 02-18-2015, 03:40 AM
  2. Replies: 11
    Last Post: 05-09-2013, 04:25 AM
  3. Replies: 2
    Last Post: 08-17-2012, 05:10 AM
  4. Conditional formatting using a rule "Contains"
    By alexlead in forum Excel General
    Replies: 4
    Last Post: 08-24-2011, 08:13 PM
  5. excel should "paste special" a "conditional formatting"
    By lozturk21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2005, 10:05 AM

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