highlight by date

Hello, I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm... It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional...

I have a holiday tracker calendar and it uses macros and formulas to calculate days and dates etc. I have this code...

In work, we have a table where in the first row is a list of the products and the first column are days of the week. Here, we list the amount of items per product needed to be delivered in the week. We do this daily. Is there a way to only highlight the cells that we edited/put numbers in for...

Hello! I'm trying to color cells within a row based on the date displayed within that row. Column A equals Column B but in day format, so when the date in column B equals a date that I'm placing in a separate cell not shown here, I want that date's row of data to be highlighted a certain...

Hi, I have a spreadsheet with an Expiration Date column, with dates ranging from some expiring this year to 2021. I need to have dates become yellow when they are less than 3 months from their expiration date and red when they are less than 2 months from expiring. I know I need to do some...

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...

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...