lboucher9960
10-18-2007, 08:04 AM
Hello to all,
I am totally new to excel and the many features it has. I am taking this one day at a time trying to learn new things. I do have a question about automatic highlighting.
I have a worksheet where I have to keep track of dates for clients to have maintenances done within a specified month . I need to automatic highlight a row of information based on a date range in a column. I want the date ranges to be different colors. Once the first date range is exhausted when changes are made, then I want the colors to update based on the oldest date range.
I hope you can understand this.
Thank you for any help you can give me
I am totally new to excel and the many features it has. I am taking this one day at a time trying to learn new things. I do have a question about automatic highlighting.
I have a worksheet where I have to keep track of dates for clients to have maintenances done within a specified month . I need to automatic highlight a row of information based on a date range in a column. I want the date ranges to be different colors. Once the first date range is exhausted when changes are made, then I want the colors to update based on the oldest date range.
I hope you can understand this.
Thank you for any help you can give me