Forum Discussion

mj786's avatar
mj786
Copper Contributor
Oct 26, 2025

Excel conditional formula

Hi

i have a problem understanding this

 I want to color highlight numbers from row 2 that is row 1 + 5

I mean if any number from row 2 + 5 equal to any number in row 1 to be formatted and filled with a color

 

What formula should i put?

excel
Formulas and Functions

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 28, 2025

    Hi

    Conditional Formatting rule with formula that Applies to $A$3:$F$3:

    =SUM( MATCH( A3 + 5, $A2:$F2, 0 ) )

    or, if you run Excel >/= 2021

    =SUM( XMATCH( A3 + 5, $A2:$F2 ) )

     

Resources