NEWBIE TO EXCEL FORMATTING

[lboucher9960]

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

[Bob Phillips]

Is all of the data date ordered?

Where is the date range, and how is it structured?

How do we know what colours with which date range?

Might be best to post an example workbook.

[lboucher9960]

Here is what the chart looks like. The columns have various info listed from column A to H, one of the columns say D, being the date. Now I need to highlight the information when it falls within a specified date range. Urgent date range needs to be in red, current date range in green, etc for whatever color I may choose for the other ranges I need. Dates are structured at mm/dd/yy.