Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting - Between 2 dates
I want to return a specific color in a project plan. In column E I have the starting date and in column F I have the end date and starting from column H I have the specific dates.
My first task in the project is on row 5 and on row 2 I have the dates written so the first date is specified in cell H2.
On row 5, the first task I want to check for the start and the end date and I want the sheet to automatically put a specific color in all the cells between those two dates.
I need some sort of in between formula :)
/Fredrik
/Freddie
