Do I use the TODAY() FUNCTION

  • Thread starter Thread starter Bernard Liengme
  • Start date Start date
B

Bernard Liengme

Read up on Conditional Formattting. Excel 2007 is great at this
Why did you start your message with that rubbish?
best wsihes
 
------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=844016
------------------------------------------------------------------------
Question: Why was EXCEL changed so radically in the the new version?

- To make money?
- To confuse people?
- To make business easier?
- To challenge people?
------------------------------------------------------------------------

Hi all

I hope someone can help me with this problem.

I Have EXCEL 2007 installed on my laptop but i am working on a file
created in EXCEL 2003.

I have been asked to create a spreadsheet to highlight an order date if
it is outstanding or if it nearing it's due date.

i think I need to use thetoday() function and also conditional
formatting ie GREEN if an item is on order or if it has arrived,
AMBER/YELLOW if it is near it's delivery date (perhaps 2 daysor so) and
RED if it has not arrived.

I have looked at various manuals and help forums but I am at a loss.
although I am new to this forum I am not totally new to EXCEL.

I would be happy to send a sample file to anyone who is kind enough to
help

I would be extremely grateful or any help or advice.

Many thanks

Shweta
 
------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=844016
------------------------------------------------------------------------
Question: Why was EXCEL changed so radically in the the new version?

- To make money?
- To confuse people?
- To make business easier?
- To challenge people?
------------------------------------------------------------------------

Hi Bernard,

Re: rubbish at beginning of message.... I don't know why I did that
silly thing at the beginning of my post! I think I was so frustrated
with not being able to resolve my problem any diversion was welcome!

Re: problem... many thanks for your reply - it is much appreciated.
 
Back
Top