Get instant live expert help on sumif less than

I need to have a formula that will determine if a contract is due to expire in less than 30 days then the cell will say "less than 30 days" and will be coloured red, if less than 60 days then says "less than 60 days" and coloured amber and if less than 90 days then says "less than 90 days" and coloured Green

What is the formula for greater than or less than on excel?

if i have criteria that needs to be met to create a specific color if e2 is less than or equal to 70, green or if e2 is less than or equal to 90, blue or if e2 is greater than 90 but f2 is is less than equal to 110, blue, or if e2 is greater than 90 but f2 is is less than equal to 115, yellow, or if e2 is greater than 90 but f2 is is less than equal to 120, pink, or if e2 is greater than 90 and if f2 is greater than 120, red

I need column D and E to be green if less than column O and Red if more than column O. I also need column F green if less than column P and red if more than column P.

6. On the Sales Sheet (It is blank). Create a lookup table. In the first column there should be the values to setup the different categories based on Total Sales. Anything less than $3000 is considered Low Sales. Anything greater than $3000 but less than $7000 is considered OK Sales. Anything greater than $7000 but less than $11000 is considered Average Sales. Anything greater than $11000 but less than $15000 is considered Above Average Sales. Anything Greater than $15000 is considered Excellent Sales.