+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Help

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    san francisco
    MS-Off Ver
    2001
    Posts
    1

    Conditional Formatting Help

    Hi all,

    Is anyone aware of any code or process limitations for conditional formatting in excel? I'm trying to use an Index(match(index(isnumber))) function in conditional formatting. My equations run as expected when I run them in a worksheet (i get the appropriate 1 or 0), however, it only conditionally formats the first 48 rows or so when i try to run it in conditional formatting manager.

    The code was working when I was using Index(match) with a wildcard "*"&value&"*", however i was limited by the 255 character search max so i had to edit the code. I have about 270 rows of data in my current workbook, but i'll need the code to work for up to 5000.

    I'm trying to conditionally format cells red when this equation is confirmed:

    =IF(AND(INDEX('PFL Data'!F$3:F$5001,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(B2, 'PFL Data'!C$3:C$5001)),0),0))<>'GIS Transmission Pipe Export'!D2,(NOT(OR('GIS Transmission Pipe Export'!D2=0,'GIS Transmission Pipe Export'!D2="Unknown",'GIS Transmission Pipe Export'!D2=""))),NOT(OR(INDEX('PFL Data'!F$3:F$5001,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(B2, 'PFL Data'!C$3:C$5001)),0),0))=0,(INDEX('PFL Data'!F$3:F$5001,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(B2, 'PFL Data'!C$3:C$5001)),0),0)))="",(INDEX('PFL Data'!F$3:F$5001,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(B2, 'PFL Data'!C$3:C$5001)),0),0))="Unknown")))),1,0)


    PFL data sheet is a range of cells with data separated by commas.


    Let me know if i can provide anymore information.


    Thanks.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional Formatting Help

    Welcome to the forum.

    To aid in finding a solution for you a workbook representative to your problem would be appreciated.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  5. Replies: 3
    Last Post: 05-15-2012, 04:13 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