Results 1 to 4 of 4

Find and Replace conditional formatting.

Threaded View

singerbatfink Find and Replace conditional... 07-12-2016, 09:33 AM
FDibbins Re: Find and Replace... 07-12-2016, 09:39 AM
AliGW Re: Find and Replace... 07-12-2016, 09:40 AM
singerbatfink Re: Find and Replace... 07-12-2016, 09:46 AM
  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Find and Replace conditional formatting.

    Hi Is it possible to use find and replace to update formula within conditional Formatting. This is my example below.

    =AND(OR('WC1'!$E$8=1))

    The conditional formatting formula has to look at 60 sheets starting with sheet WC1, and there are lost of cells like this looking at different colums within each sheet.

    I have copied and pasted the conditions to all the 60 rows where i need results but Im having to go into each condition and change the WC1 Reference to WC2, WC3 etc and its taking forever.

    Can I speed this up using find and replace (Go To Special) ?

    Thanks B
    Last edited by singerbatfink; 07-12-2016 at 09:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find and Replace, Formatting, Formatting Formula
    By kjxavier in forum Excel General
    Replies: 1
    Last Post: 07-03-2014, 09:03 PM
  2. Replies: 4
    Last Post: 05-07-2014, 03:40 PM
  3. Conditional find and replace?
    By jzsscoop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2011, 12:27 PM
  4. Replies: 1
    Last Post: 06-19-2011, 02:57 AM
  5. conditional find and replace
    By Digger442 in forum Excel General
    Replies: 1
    Last Post: 03-14-2007, 11:13 PM
  6. Conditional FIND and REPLACE
    By wisynco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-07-2006, 01:46 PM
  7. Find/Replace w/ Conditional Formatting?
    By bludovico in forum Excel General
    Replies: 1
    Last Post: 04-29-2005, 10:13 AM

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