highlight dates

Hi there, I have a spreadsheet that includes the dates and Number of days the employees have been taking sick leave in the last year. The information is shown as per the following table: <colgroup><col><col><col><col></colgroup><tbody> Full Name Leave Start Date Leave End Date Units Taken...

Hello Excel Geniuses! Hope all is well. I am in need of some assistance, and I am hoping someone can help me here... I have a workbook where months, expressed as the 1st of the month, are in row 2. Each column to the right is the subsequent month. SO for example, 10/1/2015 in BW2, 11/1/2015...

Hi all, I need some help creating a formula that will highlight a cell if the cell begins with the letter F and not A. I would like to be able to highlight past due cells as well as highlight those coming up within 2 weeks. I have half the equation but ma having some trouble on the second...

Hello, I have a problem that I have not been able to find any help on. I have spreadsheets that has 31 columns to account for each day of the every month. Each column has about 17 rows in them. I would like to be able to enter a specific day or range of days such as monday thru Friday, or...

Good day everyone. First I want to say that I have been working on this for a while and have not online looked through this forum but several others as well as Excels own help file at no prevail. So I greatly appreciate your help. To simplify things I will just use A1 as the cell I am trying to...

Okay, this is a little sticky, so I hope I can articulate it properly so that it makes sense. I have a drop-down menu at the top of a worksheet which contains the following values: Q1-2012, Q2-2012, Q3-2012, and Q4-2012. When one of these is selected I would like a cell to search a column of...