View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
TC
 
Posts: n/a
Default 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