Hi to all.
I have viewed several thousand threads (well it feels like it). Can I please request some direction regarding my current issue, and please assume I know very little about Excel.
I have a manpower spreadsheet, which depicts when individuals are due to leave the company, (by the following date format 04-Jun-12). I would like to know how I can manage it better, the plan i would like, would be to have the following:
Conditional Formatting (CF) RED for people with 12 months or less to do.
CF Amber for people with 1 to 2 years to do
CF Yellow for people with more than 2, but less than 5 years to do.
CF Green for people with 5 years or more to complete
Any help at all would be very very appreciated.
Many thanks in advance
Bookmarks