G
Guest
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?
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?