Results 1 to 4 of 4

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

Threaded View

  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.

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