bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
Hi Guys n Girls
I have a range of dates of when documents are sent in to the managers column H and what needs to be achieved is any date that is past 7days needs to be highlighted red so as to prompt an action. Secondly in column I, I would like to place R (for returned) but could be anything so that the corresponding cell in H is shaded green. Problem I'm having is all the blank cells are red (not ideal) and I cant get the green shading happening, getting frustrated that I cant figure out something this simple.
Thanks Guys <o></o>
I have a range of dates of when documents are sent in to the managers column H and what needs to be achieved is any date that is past 7days needs to be highlighted red so as to prompt an action. Secondly in column I, I would like to place R (for returned) but could be anything so that the corresponding cell in H is shaded green. Problem I'm having is all the blank cells are red (not ideal) and I cant get the green shading happening, getting frustrated that I cant figure out something this simple.
Thanks Guys <o></o>