Select column D and crate Conditional formatting with this formula:
=NOT(ISERROR(MATCH(-D1,D:D,0)))

Regards,
Stefi

€žEric D€� ezt Ã*rta:

Is there a way that I can use conditional formatting with an IF statement?

What I want to happen is, if in column D there appears a number that has an
opposite match (i.e. 500 and -500) that it highlights those. Is this
possible and if so, how?

Thanks
--
Eric