Format cell colors based on another cell values with positive and negative numbers

Hi this forum has been very helpful in the past and I am currently stuck on formatting the color of one cell based on different criteria of another cell.

Here are the details.

If C22 is +0.01 to +0.50 cell B22 is Green
If C22 is -0.01 to -0.30 cell B22 is Yellow
If C22 is equal to or greater than +0.51 cell B22 is Red
If C22 is equal to or greater than -0.31 cell B22 is Red (Here I am saying that if C22 is -0.31 or -0.38 or -0.41, not sure if a larger negative number is greater than or less than.)

That's it. I have been successful at changing cell C22 to these colors but now that I am trying to change adjacent cells based on C22 values, I can't seem to do it.

Thanks for your help and insight.

Select cell B22 and do the same as before

I am sorry but I am still having trouble. I select cell B22 and go to Conditional Formatting. Click on new rule and formula. Now it asks for a formula do I use IF(c22=>+0.51)? I have tried various permutations but nothing works. Sorry I am such a noob at this. Can you give me some specific help? Thanks.

Select B22
in CF use the same formulas as before
Should be:
=AND(C22>0.01,C22<0.5) for green
the rest is similar

btw. + in front of number is not neccessary because it is always plus

Thank you. I will try this right away.

Sorry for the: use the same formulas as before but I assumed you did all rules correctly

Well, that didn't work. I am sorry to be so dumb about this.

Thanks.

OK. The 2 red fills worked. But the green and yellow did not work. I put them in the order you listed. Does the order matter in this instance?

YES. SUCCESS!

Thank you for your help and patience. I have spent the morning trying to make this work. Whew.

You are welcome

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks