Results 1 to 7 of 7

Conditional Formatting using data in Sheet2 to change colors of cells in sheet1

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2005
    Posts
    8

    Conditional Formatting using data in Sheet2 to change colors of cells in sheet1

    I have an office lottery pool. Each of us pick 6 numbers from a range of 1 through 60. This is on sheet1. Sheet2 contains the actual drawn numbers. Rows on sheet2 are labelled by week number. I want all the cells in sheet1 to have conditional formatting that will change the cell color to red if they match any cell from the cells that contain the drawn numbers in sheet2. Can someone please help me on this?

    I actually asked this question in a LibreOffice forum because thats what I have at home and thought that maybe it would work for Excel at my work place. But unfortunately the answer I got only works for LibreOffice. I understand that cross posting is frowned upon but I really would like to know how I can get this to work on Excel. Below is what i got to work in the other spread sheet program. I will attache my document without any conditional formatting. Thanks.

    Condition 1 Dropdown:
    Formula is
    and
    SUMPRODUCT(B1=Sheet2.$B$1:$F$52)
    Apply Style:
    BGRed
    Cell Range
    B1:G3
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-15-2017, 06:28 PM
  2. Macro to change colors of sheets data both sheet1 and sheet2 data same
    By toravietl in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2017, 02:33 PM
  3. [SOLVED] Conditional formatting to change colors of Columns based on data entered in Column E
    By JJFletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2016, 01:27 PM
  4. [SOLVED] Conditional formatting if A1 in sheet1 is not = A1 in sheet2 applied to a range
    By Mattlawson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-09-2015, 09:10 PM
  5. conditional data from Sheet1 populate Sheet2
    By skibumjim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 03:00 PM
  6. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  7. [SOLVED] Copy colors / names from Sheet2 to Sheet1
    By Berna11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2013, 10:58 AM

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