Any MS Excel gurus here?

[n666]

Hey all..
i know this probably belong more in the software section, but i figured a lot more people read this part of the board.. anyway here's my task:

A Date is being pulled from a cell in document "delivery.xls" into a cell in "report.xls"
I need excel to find out if that date is > todays date... so say today is 15th and if the date in the cell is 17th, i want it to be displayed in red.

Check out the image to understand a little bit more..

Text

Right now the text is in black.. i need it to be in red if the date is larger then todays date.. and in black if it's not..

i hope this makes sense

 

[minendo]

Use conditional formatting.

Format --> Conditional Formatting

 

[yukichigai]

Hrrrrrrrrm....

It's been a while, but I believe there's a tag for color you can insert into the if statement. If I had excel on this computer I could tell you the precise syntax in a heartbeat. I think it's something like this.

if(<condition>, xx:nn, [red]xx:nn);


EDIT: Or yeah, use conditional formatting. D'oh.

 

[n666]

niiiiice


learn something new everyday

thanks x1000