Highlight postive &negtivevalues that are pposite & equal

[Howardc1001]

I have a workbook where I have values in Col A


I would like to set up CF to compare the values in Col with those in Col B to D

Where the values are the same but the one is for eg positive and the other negative or vice versa for eg if A2 is 100 and B5 is -100 , then both values must be highlighted in yellow


I have attached sample data


Your assistance is most appreciated

[WideBoyDixon]

Highlight column A and add a new conditional format based on the following formula:

Please Login or Register  to view this content.

Then highlight columns B:D and add a new conditional format based on the following formula:

Please Login or Register  to view this content.

Choose your highlighting as you wish.

WBD

[Howardc1001]

Many thanks for the help. your CF formula works perfectly