[ms office - 2003] Conditional Formatting

[garethEds]

One for the Excel gurus. I've been using some functions in Excel to work out which days of a range of days are weekends (networkdays function). It is very good and one I hadn't seen before.

 

How can someone help me with the following.

 

I have a sheet which represents the month of May. It is formatted into a range of cells representing the days of the month.

 

Row 1 (cells 2 to 32) are the dates.

 

On another sheet, I have a cell where I can put a start date and another cell where I can put an end date.

 

Now depending on these dates I put in, how can I get the cells on the month sheet to either colour themselves or have a text label entered into the cell?

 

Does that make sense?

 

So it works kind of like a diary. Example:

 

Start Date: 01/05/2010

End Date : 14/05/2010

Total of days: 13

 

So on the diary page, it colours in Cells A2:A15 in Red.

 

Gareth

[andy_b]

I think I understand what you want

 

Sadly, conditional formatting (at least in 2003) can't refer to cells on another sheet, so i had to have two hidden columns.

 

Hope its ok.

dates.xls