Posted to microsoft.public.excel.newusers
|
|
Conditional Formatting Date
Try formula is =f1<a1.
TC
"Humpy" wrote:
Can you help!
I have set up an Excel spreadsheet as follows:
A B C D
E F
1 DATE NAME INVOICE AMOUNT TERM DUE
DATE
2
=SUM(A2+E2)
3
4
5
Is there a formula I can use so that cell F2 turns red once we've
passed the due date.
--
Humpy
------------------------------------------------------------------------
Humpy's Profile: http://www.excelforum.com/member.php...o&userid=31895
View this thread: http://www.excelforum.com/showthread...hreadid=516342
|