If Statement

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:

Please Login or Register  to view this content.

Hope I explained that well enough.

Thank you all in advance.

Originally Posted by DonkeyOte

With A1 the active cell the conditional formatting formula would be:

=AND(LEFT(C1)="P",CEILING(N1,6)=6,O1="MONTHS")
format Green

Using N/O avoids false positive issues where a string of say "10-MONTHS" would be treated as being between >= "0-MONTHS" and <= "6-MONTHS"

Okay, this works good, but I have alot more options than just the three it allows me on conditional formatting. Is there a way that I can make it look at that cell and see if it has multiple letters say, "P", "S", "B"?

And if it is either one of those then change the condition.

Thank you for your help!!!!

Originally Posted by DonkeyOte

With A1 the active cell the conditional formatting formula would be:

=AND(LEFT(C1)="P",CEILING(N1,6)=6,O1="MONTHS")
format Green

Using N/O avoids false positive issues where a string of say "10-MONTHS" would be treated as being between >= "0-MONTHS" and <= "6-MONTHS"

Also, what does the "6" mean that is next to the " N1"?

Thank you so much DonkeyOte!!!!

I did modify the formula just a hair but it worked beautifully!!!!

Thank you so much.