Conditional Format Formula

I need help writing two conditional format formulas. One formula needs to highlight column (A) if the percentage is improving and getting closer to zero than column (B) and as well column (C). For example A=1 B=-3 and C=2, column (A) would highlight green since it's getting closer to zero it's trend is improving. The other needs to do the opposite were if A=-4 B=-2 and C=-3 column (A) would highlight red because it is not the closest to zero it's trend is further away.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic

Try these two rules under the "use formula to determine which cells to format" selection (red): =AND(ABS(A2)>ABS(B2),ABS(A2)>ABS(C2)) and (green): =AND(ABS(A2)<ABS(B2),ABS(A2)<ABS(C2)) Here is a copy of your file with the CF rules applied: Conditional Formatting of Absolute Value.xlsx
Let me know if you have any questions.

You're Welcome and thank you for the feedback. If you haven't already, please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.