Coniditional formatting

Closed
Tony - Aug 17, 2012 at 03:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 11, 2012 at 10:34 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 11, 2012 at 10:34 AM
Use conditional format for that
0