+ Reply to Thread
Results 1 to 5 of 5

Highlight a cell D3, if any number in K3:O3 matches?

  1. #1
    Registered User
    Join Date
    12-08-2022
    Location
    Compton
    MS-Off Ver
    2010
    Posts
    1

    Lightbulb Highlight a cell D3, if any number in K3:O3 matches?

    (This is for Google Sheets)

    If a number in the "Numbers Played" row shows up in the "Winning Numbers" section on the right, in the same row, I need it to highlight that number.

    I thought I had it working, but in the 4th row, in the "Winning Numbers" section there is a 19, and there is also a 19 in the "Numbers Played" section, but it's not highlighting.

    How can I get the "Numbers Played" row to highlight a number, if that number is in the same row on the right, in the "Winning Numbers" section?

    (I would post a link but it's not letting me)

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Highlight a cell D3, if any number in K3:O3 matches?

    In Excel,
    Please Login or Register  to view this content.
    would work.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Highlight a cell D3, if any number in K3:O3 matches?

    Have a look at this and see if it is the conditional formatting you're looking for.

  4. #4
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Highlight a cell D3, if any number in K3:O3 matches?

    How about this:
    =COUNTIF($K$3:$O$30,$O3)>1

    Attachment 808648

  5. #5
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Highlight a cell D3, if any number in K3:O3 matches?

    In this Sheet, for each row, the Numbers Played cell will be highlighted if any number in the Winning Numbers section match the Numbers Played. If that is not what you're looking for, let us know.

    Click any of the Numbers Played cells, it will open the Conditional Formatting dialog box.
    Last edited by Flyboy65; 12-10-2022 at 10:51 AM.

+ 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. Conditional Format to highlight rows if cell below matches
    By pandagurlie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-18-2021, 05:25 AM
  2. Replies: 3
    Last Post: 11-22-2021, 03:09 PM
  3. [SOLVED] Conditional formatting (special, highlight if cell matches value after : symbol)
    By rayted in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2021, 03:38 AM
  4. [SOLVED] highlight cell through conditional formatting if the date matches ?
    By VICTOR5 in forum Excel General
    Replies: 7
    Last Post: 01-01-2019, 02:11 AM
  5. Replies: 6
    Last Post: 02-21-2018, 01:15 PM
  6. Is it possible to highlight number matches?
    By Astralogic in forum Excel General
    Replies: 4
    Last Post: 11-27-2017, 09:41 AM
  7. Replies: 7
    Last Post: 03-25-2013, 06:07 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