This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Greetings all,
I have this situation. I need to get formulas for
• between today and past due to be red
• between yesterday and 30 days before to be yellow
• between 60-30 days before to be green
These dates were added the day the actual forms happened so they need to be at the one year mark for E all the way to L
Hi @Ramon Sanchez ,
Which columns did you need to create the conditional formatting?
And your conditions are not described clearly, please be a bit more precise to explain your requirement so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 77%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi ,@Ramon Sanchez ,
Conditional formatting formulas are as follows
RED
=AND(DAYS(TODAY(),$A1)=TODAY(),DAYS(TODAY(),$A1)<TODAY())
YELLOW
=AND(DAYS(TODAY(),$A1)=1,DAYS(TODAY(),$A1)<30)
GREEN
=AND(DAYS(TODAY(),$A1)<=30,DAYS(TODAY(),$A1)<=60)
Apply these formulas with correct cell address with your data and check whether it working ,what you wnted to with.
Hope this helps
Sukanya