acertco03dis
06-23-2016, 05:59 AM
Hello everybody.
Currently, I have a range of cells that each have a date within them. On the top of the spreadsheet, I have a beginning and end date that I will change depending on when the spreadsheet is run. Would anyone be able to provide me with a formula or macro that will change the color of the cell with the date to either red or green depending on if that date falls in between the beginning and end date? Any help would be appreciated. Thanks!
Currently, I have a range of cells that each have a date within them. On the top of the spreadsheet, I have a beginning and end date that I will change depending on when the spreadsheet is run. Would anyone be able to provide me with a formula or macro that will change the color of the cell with the date to either red or green depending on if that date falls in between the beginning and end date? Any help would be appreciated. Thanks!