“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by E. S. in 14 mins

How can an "IF" 'less than or equal to' formula be done in Excel?

Solved by I. A. in 25 mins

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.

Solved by E. C. in 23 mins

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

Solved by K. H. in 24 mins

If a calculated cell is less than 0 = 0, if the same cell is greater that 0 that multiplied by 12 a1:a4 if greater than zero a5 x 12 if a5 is less than 0 = 0

Solved by G. H. in 21 mins