Forum Discussion
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 fill...
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 ) )