Forum Discussion

Jna3276's avatar
Jna3276
Copper Contributor
Sep 02, 2024
Solved

Conditional formating using formula

Hi,   I'm looking to apply a conditional format to a table (Table1) which highlights the row where a cell matches a cell within another table (Table2)   I've had a look online, the only thing I c...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 03, 2024

    Jna3276 

    Select the data rows of the table on Sheet 1 (i.e. A2:G8).

    Create a conditional formatting rule of type 'Use a formula to determine which cells to format' with formula

    =ISNUMBER(XMATCH($A2, Sheet2!$C$2:$C$5))

    or

    =COUNTIF(Sheet2!$C$2:$C$5, $A2)

    You can't use structured table references in conditional formatting rules. But Excel will automatically adjust the rule when the table expands/shrinks.

HansVogelaar's avatar
HansVogelaar
MVP
Nov 15, 2024

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

HAROON1's avatar
HAROON1
Copper Contributor
Nov 16, 2024

WHEN I AM APPLYING THE CONDITIONAL FORMATION FORMULA IT IS ONLY 1 CELL, I WANT IT TO HIGHLIGHT THE WHOLE ROW THE FORMULA IT IS USING =SEARCH ("OK", C2) CONDITION IS THAT WHEN I WILL TYPE "OK"IN COLUMN D 

  • HAROON1's avatar
    HAROON1
    Copper Contributor
    Nov 20, 2024

    ACTUALLY, I WAS ABLE TO SOLVE THE PROBLEM THROUGH THIS FORMULA =SEARCH ("OK", $D2) THIS FORMULA IS HEIGHLITING THE FULL ROW 

Resources