If Statement

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"?