Excell Color Formula Help
Hello!
I am trying to add some color-based formatting to an excel sheet. The goal is to have all dates be yellow until 7 days after the date I have inputted. Then I would like them to turn green.
I am running into some problems as some of the dates being inputted are for the future and I cannot seem to find a good excel formula or formatting solution to fix this!
Appreciate any help as I am new to excel!
Thanks!
Hello! I am trying to add some color-based formatting to an excel sheet. The goal is to have all dates be yellow until 7 days after the date I have inputted. Then I would like them to turn green. I am running into some problems as some of the dates being inputted are for the future and I cannot seem to find a good excel formula or formatting solution to fix this!Appreciate any help as I am new to excel! Thanks! Read More