Conditional Formatting

[leeannjanee]

I have pretty average skills when it comes to excel but I'm trying to help a friend out by creating a spreadsheet.

In this spreadsheet he's asked me to highlight if people have had a good weight loss/gain that week. As people have different goals, I'm not sure how to change the conditional formatting for this.

So, if someone's goal is to lose body fat, I want it to:
Highlight red for greater than 0
Highlight amber for equal to 0
Highlight green for less than 0

Then for someone who is trying to gain muscle mass, or weight, I want it to:
Highlight green for greater than 0
Highlight amber for equal to 0
Highlight red for less than 0

And for someone who is trying to maintain their weight, I want it to:
Highlight red for less than or greater than 0
Highlight green for 0

I've tried looking at AND and IF formulas for this but I can't get it to work.

Thanks for anyones help in advance

[arlu1201]

Hello leeannjanee,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.