bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
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.
I have been given "IN cell H3 type =TODAY(), this will put today's date in that cell
In Cell H4, conditionally format with the following formula:=IF(H4<$H$3-7,1,0)" and " In Cell H4, conditionally format with the following formula:=IF(H4=$I$3,1,0) for the green shading" but this doesnt work correctly??
Thanks Guys
I have been given "IN cell H3 type =TODAY(), this will put today's date in that cell
In Cell H4, conditionally format with the following formula:=IF(H4<$H$3-7,1,0)" and " In Cell H4, conditionally format with the following formula:=IF(H4=$I$3,1,0) for the green shading" but this doesnt work correctly??
Thanks Guys