+ Reply to Thread
Results 1 to 2 of 2

conditional formatting between sheets

  1. #1
    Registered User
    Join Date
    03-24-2011
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Talking conditional formatting between sheets

    Alright.. I'm making a table where I'll be using values from one sheet (sheet2!), to compile a list in another (!sheet1). I want to make sure I use every value in sheet two, but no more than once. I was trying to use conditional formatting to highlight the cell in sheet 2 after its used, and make the text bold and italic if it was used twice. Any ideas on how to do so? I can't figure out how to enter the formula manually. I realize it would be easier if it were all in the same sheet, but I'd like to keep them separate.

    Also, just a quick thought/question.. If one refers to a library in excel, what exactly does that mean? Is there somewhere you can enter values to use? Or is a group of data (like mine in sheet2) just considered a library?

    Thank you in advance, guys

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: conditional formatting between sheets

    You will need to first name the Sheet1 range, through Formulas|Define Name

    Then select the Sheet2 range and go to Home|Conditional Formatting|Manage Rules

    Click New Rule and select Use formula to determine which cells to format

    then enter formula like:

    =COUNTIF(NamedRange,A1)=1

    where NamedRange is the column named from sheet1, and A1 is top most cell selected to format.

    Click format and choose from Pattern tab.

    Click Ok. Click New formula and do as above with formula

    =COUNTIF(NamedRange,A1)>1

    and click Format and use the Border/Font/Number tabs.. to format

    Click Ok, click Ok to finish.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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