Get instant live expert help on I need help with excel if color
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Excel Formula for Renew Date COLOR If Renew Date IS 365 DAY's Past Due Or OVER 365 DAY'S FROM TODAY Date - Make COLOR RED If Renew Date IS 10 DAY's Or Less FROM Today's Date - MAKE COLOR ORANGE If Renew Date IS 11 TO 30 Day's From Today's Date - MAKE COLOR YELLOW If Renew Date IS 31 TO 365 Day's From Today's Date - MAKE COLOR GREEN If Renew Date IS 366 Day's Or More From Today's Date - MAKE COLOR GRAY
Solved by F. Q. in 29 mins
I want to set the background color for my cells but don't know the right formula, for example If "processed" (color=green) or if "declined" (color =red)
Solved by V. J. in 13 mins
i have problem if given values are increased above 100 it will it highlight the color using conditional formatting in excel
Solved by D. L. in 24 mins
i am looking for excel formula help. i am looking a formulation that will do the following 6 conditions: if cell A1 =1 and cell B2 is <150 then make fill color in cell B2 red if cell A1 =2 and cell B2 is <120 then make fill color in cell B2 red if cell A1 =3 and cell B2 is <90 then make fill color in cell B2 red if cell A1 =4 and cell B2 is <60 then make fill color in cell B2 red if cell A1 =5 and cell B2 is <30 then make fill color in cell B2 red if cell A1 >= 6 then nothing happen to cell B2
Solved by K. S. in 11 mins
ease use Column L M N for formula's and Column F 3 - 3000 for color dates. Yesterdy I asked help in making Formula for 5 Colors Different Date If Date IS 365 DAY's Or Olded FROM TODAY-Make COLOR RED If Date IS 10 DAY's Or Less FROM Today-MAKE COLOR ORANGE If Date IS 11 TO 30 Day's From Today-MAKE COLOR YELLOW If Date IS 31 TO 365 Day's From Today-MAKE COLOR GREEN If Date IS 366 Day's Or More From Today-MAKE COLOR GRAY
Solved by B. C. in 24 mins