Hello all,

I am looking for a way to change the color of a cell based on the result. I have tried conditional formatting. What I need is a little more complicated though.

I am assuming that I need an "IF" formula, but I am not sure how to do it. I'm teaching myself formulas as well as VBA at the same time, and I think I am confusing myself.

What I need is: For the cell formula to look at another cell's value and see what letter that it's value starts with. Then I need it to look at it's own value and then based on those two conditions adjust the color of the cell acordingly.

Example: My if formula is in A1 and it is looking at C1. If C1's value starts with say a "P" then look at A1's value. If it is between "0-MONTHS" and "6-MONTHS", then change the color of the A1 cell green.

I also already have another formula in A1. It is:
=N1&"-"&O1
Hope I explained that well enough.

Thank you all in advance.