Results 1 to 3 of 3

Conditional Formatting not working.

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional Formatting not working.

    Hello everyone. Long time reader, first time poster. Excel 2010.

    I have a Conditional format that is not working. The CF is located in O60:O63. My formula for the Condition is:

    =OR(INDIRECT(SUBSTITUTE(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),ROW(),"")&IF(COUNTA($A:$A)<32,7,MAX($C$21+16,59)))="Part Rate (%)",INDIRECT(SUBSTITUTE(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),ROW(),"")&IF(COUNTA($A:$A)<32,7,MAX($C$21+16,59)))="Perf Weight (%)")

    Basically saying if the title of my column (it moves-hence the formula) is equal to "Part Rate (%)" or "Perf Weight (%)" then make it Red and format it as a percentage. Neither format changes. If I copy paste the formula itself into the cell, it says TRUE (I pasted the formula itself into O63 as an example).

    These cells were copy/pasted from Columns to the right starting at row 7. I need them to format based on the title of the column. The row of the column varies.

    TIA.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting VBA not working
    By ArtySin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-12-2013, 07:41 PM
  2. Conditional Formatting not working?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2013, 11:31 AM
  3. Conditional Formatting not Working
    By braydon16 in forum Excel General
    Replies: 7
    Last Post: 05-23-2012, 02:41 PM
  4. Replies: 0
    Last Post: 01-20-2009, 05:19 PM
  5. Several Conditional Formatting only working on some
    By joblinger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2009, 05:17 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