daraghofla
New Member
- Joined
- Jul 19, 2007
- Messages
- 41
Hi all.
I am looking to design an excel sheet which indicates when someone's term is within a month of it's end.
It will include the individual's name, his/her start date, finish date and priority. The priority being a cell which is a specific colour. For example, it'll be green if the finish date is more than a month away. However, I would like the colour of the cell to be red if the persons finish date is within a month.
This is how I would picture the excel file but of course there might be easier or indeed better way of doing it via excel.
What I am really looking for is an example of the formula that I would have to put into the priority cell.
Any help would be much appreciated
Daragh
I am looking to design an excel sheet which indicates when someone's term is within a month of it's end.
It will include the individual's name, his/her start date, finish date and priority. The priority being a cell which is a specific colour. For example, it'll be green if the finish date is more than a month away. However, I would like the colour of the cell to be red if the persons finish date is within a month.
This is how I would picture the excel file but of course there might be easier or indeed better way of doing it via excel.
What I am really looking for is an example of the formula that I would have to put into the priority cell.
Any help would be much appreciated
Daragh
