Results 1 to 12 of 12

How to compare cells and format conditionally over a whole sheet

Threaded View

  1. 05-30-2014, 09:43 AM #6
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to compare cells and format conditionally over a whole sheet

    TRY

    Formula: copy to clipboard 
    =AND($A3=Sheet1!$A3,$B3=Sheet1!$B3)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help looping through multiple sheets to conditionally format the same range/sheet
    By xcelnovice101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2014, 10:54 AM
  2. Macro to Conditionally Format Cells based on another cells value
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-07-2013, 03:05 AM
  3. Conditionally Format Formula for cells containing numbers
    By slipleft in forum Excel General
    Replies: 6
    Last Post: 10-13-2011, 11:30 AM
  4. How can I conditionally format cells that contain formulas?
    By jhofmann in forum Excel General
    Replies: 2
    Last Post: 04-06-2006, 11:10 AM
  5. [SOLVED] conditionally format cells
    By elad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2005, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1