+ Reply to Thread
Results 1 to 3 of 3

Trying to use conditional format when a cell is also in a separate worksheet range

  1. #1
    Registered User
    Join Date
    10-24-2014
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    14

    Trying to use conditional format when a cell is also in a separate worksheet range

    Hi,
    Column A of Sheet 1 has the results of an audit of serial #'s perform.
    Column A of Sheet 2 lists only the serial #'s I'm interested in. (A subset of the column mentioned prior)

    How do I use a formula in conditional formatting to highlight the cells in Sheet 1 that are present in sheet 2?

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Trying to use conditional format when a cell is also in a separate worksheet range

    You can use CF with formula ("Use a formula to determine which cells to format"). In sheet 1 try,

    =COUNTIF(Sheet2!$A:$A,$A1)

    where A1 is the starting cell for the conditional formatting. IF countif is >=1, i.e. if value is also present in Col A in Sheet1, the formula will recognize it as True.

  3. #3
    Registered User
    Join Date
    10-24-2014
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    14

    Re: Trying to use conditional format when a cell is also in a separate worksheet range

    Thanks for the suggestion. I got the error "You may not use reference operators or array constants for conditional formatting criteria when I tried it

+ 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. Replies: 4
    Last Post: 04-29-2014, 05:02 PM
  2. Conditional Format a range of cells if active cell is not in the range to be formatted.
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2013, 05:49 AM
  3. run conditional format formula from another cell in another worksheet
    By mook25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2013, 10:42 AM
  4. Using Conditional Formatting to format range based on one cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2012, 09:50 PM
  5. Help! Need to move rows to separate worksheet if cell values match a value in range
    By nzamparo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2011, 12:20 AM
  6. Conditional Format a cell based on a range of numbers
    By fablhof in forum Excel General
    Replies: 2
    Last Post: 04-27-2007, 11:39 PM
  7. VB Code to Conditional Format a Cell Range
    By VCSGroup in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2005, 05:35 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