+ Reply to Thread
Results 1 to 4 of 4

Conditional Format "Applies To" Changes, Don't Want it To

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Conditional Format "Applies To" Changes, Don't Want it To

    Hello,

    So I have a conditional formula that highlights blank cells in 5 columns (D,E,G,H,I) if the reference column (B) has an entry. The "Applies To" columns in the formatting rule are absolute references, and the rule works the way it should....

    However, I was working in column K: if I add text, enter and delete it the cell is automatically highlighted; and when I checked the conditional format rule, that cell is now added to the "Applies To" field.

    Why is this happening? And more importantly, how do I stop it?

    Thanks for the help.

    EDIT: I just realized another thing.. this only happens to the cells that have no blank cells in any of the columns mentioned above.
    Last edited by aaallday; 10-20-2015 at 02:11 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Conditional Format "Applies To" Changes, Don't Want it To

    I can't reproduce that issue. Can we have more information?
    Are B:K part of a Table?
    Does this conditional formatting cover multiple rows?
    When you say you delete the cell in K, do you simply clear it or do you delete it? If you delete it, do you then move cells up or left?
    Conditional formatting is only connected to D,E,G,H,I and not to any columns to the right of K?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-23-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Conditional Format "Applies To" Changes, Don't Want it To

    Thanks for the help..

    First, not a table but columns are filter-able -- A:Y is the total range
    Yes, the conditional format covers all row (currently 240 rows) and 100 more blank rows
    When I delete the text (not the cell). I type in "dfasdf", then delete the cell contents.
    No, nothing to the right of K

    Here is the rule:
    =AND(ISTEXT($B3),ISBLANK(D3))

    Here is what my "applies to" looks like after a couple of text/deletes:
    =$D$3:$E$350,$G$3:$I$350,$K$11,$K$13,$K$16,$K$3,$K$1

  4. #4
    Registered User
    Join Date
    09-23-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Conditional Format "Applies To" Changes, Don't Want it To

    So far the only thing that has help avoid this issue is if I insert a blank column before K. I guess this breaks whatever "continuity" excel is trying to create. This is not an ideal solution though - prefer not to have useless columns in my doc.

    Any ideas?

+ 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. Return the conditional formatting "Applies to" range?
    By mansfin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2015, 08:25 AM
  2. Conditional Format "Applies To" When Adding Rows or Columns
    By robot.crasher in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-12-2015, 06:23 PM
  3. [SOLVED] formula help: conditional format of one column based on "YES"/"NO" content of four others!
    By 10 Dollar Bill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2014, 01:59 PM
  4. [SOLVED] Conditional formatting "applies to"
    By bentod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2014, 04:29 PM
  5. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  6. Replies: 2
    Last Post: 02-05-2013, 02:35 PM
  7. Replies: 2
    Last Post: 03-09-2010, 01:25 PM

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