Date manipulation

Hi,
I have a table row that has date values in it. I write 2008-06-13 and it displays as June 13, 2008. My problem, is that I would like all those cells to have a conditional formating that would allow me to have a certain set of icon (the one named "3 traffic lights") I would like to have a green icon if the date corresponds to a date that is before today's date, a yellow if it corresponds to today's date, and a red one if it corresponds to a future date. I have tried all the ways I could possibly think...and now I'm begging for help !!

Could someone point me in the good direction !

Thanks

I hope I understand your problem.

If you want to need three different colors, you need to setup 3 different conditional formats.

1. Select the cell on which you would like to apply the format
2. Go to FORMAT-CONDITIONAL FORMAT
3. In the first dropdown box, select "formula is"
4. Enter this formula: =A1<TODAY()
*Note: Change A1 to the cell that you are working with.
5. Choose a format
6. Click add and use the formula =A1>TODAY() for dates after today's date
7. Repeat for each condition

Report back if this helps.

ok I'm going to try this as soon as I get home !

Is there any way to have this working using a general formula....so instaid of using A3, I would use something else that would allow me to apply the same formula to all my row.

But now I have another problem...I also have 2 rows. One with Starting hours, and other with Ending Hours...so the value of the ending hours is always bigger than the starting hours...Those to rows are formated so that I enter let's say 9:00:00 and it displays as 9h00. But the problem is that If I enter 15:00:00 in the starting row (B4) and 18:30:00 in the ending row (C4), then in C5, I do =IF(HOUR(C5-B5)>0;HOUR(C5-B5);"") ...and it gives me 3 h (it should be like 3.5 h. I added a custom format to this cell and it is : 0" h".

Someone know what is the problem ?

Solved-----