Coniditional formatting

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to write a code that will scan input dates and compare them with dates in the cell
next to them. If the dates input are farther than a week out i want to color the cell green; if the cell is greater than the one next to it, but less than a week greater, then i want to color the cell yellow; if the cell input is less than the cell next to it then i want the cell to turn red. Would anybody be able to help me with this problem?

Thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Use conditional format for that