IF function
 

Using Excel 2003 - I want to create a function that changes the colour of the
text (or highlights the cell) if the function returns a date that is after
the current (today's date)

I have a coloumn of dates. The next column calculates and end date 365 days
forward. I want cells in this column to be highlighted (or text in another
colour) when the date is after the current date. (ie as due dates come around
and expire, I am abel to easlity differentiate between them and those not yet
due)

I'm thinking that this would be done with an IF function, but I have not
used these before. Can anybody help?? please?

IF function
 

Use Formats/Conditional formatting with condition Cell value greater than
=TODAY()

Regards,
Stefi

€žArtstitches€� ezt Ã*rta:

Using Excel 2003 - I want to create a function that changes the colour of the
text (or highlights the cell) if the function returns a date that is after
the current (today's date)

I have a coloumn of dates. The next column calculates and end date 365 days
forward. I want cells in this column to be highlighted (or text in another
colour) when the date is after the current date. (ie as due dates come around
and expire, I am abel to easlity differentiate between them and those not yet
due)

I'm thinking that this would be done with an IF function, but I have not
used these before. Can anybody help?? please?