+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Across Multiple Sheets

  1. #1
    Registered User
    Join Date
    10-07-2016
    Location
    US
    MS-Off Ver
    2013
    Posts
    2

    Conditional Formatting Across Multiple Sheets

    Currently, I have a spreadsheet that displays about 35k rows of information which is updated with a brand new sheet about every two months by an outside agency.

    I have added a search function and two other buttons to help individuals search the sheet and when a match is made the row is then highlighted yellow using this function (conditional formatting):

    =AND($B$2<>"",OR(ISNUMBER(SEARCH($B$2,$A6:$L6,1))))

    Is there a way to use the original sheet and above function to continue to search but also look into other sheets once they become available? This may be getting into VB?

  2. #2
    Registered User
    Join Date
    10-07-2016
    Location
    US
    MS-Off Ver
    2013
    Posts
    2

    Re: Conditional Formatting Across Multiple Sheets

    back to the top.

+ 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. Conditional Formatting (I think?) with Multiple Sheets
    By DocBenzedrine in forum Excel General
    Replies: 3
    Last Post: 01-27-2014, 05:55 AM
  2. [SOLVED] Conditional Formatting across Multiple Sheets
    By madness in forum Excel General
    Replies: 2
    Last Post: 04-10-2013, 06:09 AM
  3. Need help with conditional formatting over multiple sheets
    By tschwitz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2012, 12:20 PM
  4. Conditional Formatting For Multiple Sheets
    By Mhz in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-07-2012, 12:54 PM
  5. Conditional formatting duplicates across multiple sheets
    By joseph.noonan in forum Excel General
    Replies: 5
    Last Post: 01-26-2012, 10:41 AM
  6. Excel 2007 : Conditional formatting - multiple sheets
    By Spike0907 in forum Excel General
    Replies: 4
    Last Post: 01-31-2011, 12:11 PM
  7. Conditional formatting multiple sheets?
    By preddy1110 in forum Excel General
    Replies: 1
    Last Post: 11-23-2010, 09:09 AM
  8. VBA Conditional Formatting Multiple Sheets
    By Michael Chandrapal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2010, 05:15 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