Color-code a date

[alexander]

I would like to be able to add a formula to a Column containing a series of dates so that when the spreadsheet is opened, if the date when it's opened (i.e. TODAY) is among the listed dates, it shows up in red. I just want to be able to see at first glance projects that are due TODAY.
I know that Excel represents dates as a number so if I can find a way to give conditional formatting to the column for this to happen, it will be resolved. I found a similar one in the Forum, like this

=MAX(1:1)=A$1

for row 1, but it only works for rows. It doesn't work for columns.
If someone can help I will be thankful.

[mangesh_yadav]

Just select the entire column and go to conditional formatting. Use the Cell Value is equal to:
=TODAY()

Also take care to go back and check whether the formula you entered is not ="TODAY()", but just plain =TODAY() i.e. without the double quotes

Select the required format.

- Mangesh

[alexander]

That did the trick. Thank!

Now, what if I wanted all previous dates (to TODAY) to show up in a different color? I guess I have to add a rule to the conditional formatting, but I'm not quite sure about the formula.

[mangesh_yadav]

Conditional formatting works for 3 conditions only. Your TODAY() has already taken up one space. You have spave for 2 more conditions. When you open the conditional formatting box, you can see an ADD at the bottom. Use it to specify the condition, for example if you want to add a new condition say all ates less than TODAY, then use:
After select the cells, go to conditional formatting, click add for the second condition and choose:
Cell value is less than TODAY() and choose formatting for the second condition.

- Mangesh