software

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

5Is there a formula I can use so that cell F2 turns red once we've
passed the due date.--
Humpy
------------------------------------------------------------------------
Humpy's Profile: www.excelforum.com/member.php...oamp;userid=31895
View this thread: www.excelforum.com/showthread...hreadid=516342Try formula is =f1lt;a1.

TC

quot;Humpyquot; wrote:

gt;
gt; Can you help!
gt;
gt; I have set up an Excel spreadsheet as follows:
gt;
gt;
gt; A B C D
gt; E F
gt; 1 DATE NAME INVOICE AMOUNT TERM DUE
gt; DATE
gt;
gt; 2
gt; =SUM(A2 E2)
gt;
gt; 3
gt;
gt; 4
gt;
gt; 5
gt;
gt;
gt; Is there a formula I can use so that cell F2 turns red once we've
gt; passed the due date.
gt;
gt;
gt; --
gt; Humpy
gt; ------------------------------------------------------------------------
gt; Humpy's Profile: www.excelforum.com/member.php...oamp;userid=31895
gt; View this thread: www.excelforum.com/showthread...hreadid=516342
gt;
gt;

Sorry that should of been =f2lt;a2.

quot;Humpyquot; wrote:

gt;
gt; Can you help!
gt;
gt; I have set up an Excel spreadsheet as follows:
gt;
gt;
gt; A B C D
gt; E F
gt; 1 DATE NAME INVOICE AMOUNT TERM DUE
gt; DATE
gt;
gt; 2
gt; =SUM(A2 E2)
gt;
gt; 3
gt;
gt; 4
gt;
gt; 5
gt;
gt;
gt; Is there a formula I can use so that cell F2 turns red once we've
gt; passed the due date.
gt;
gt;
gt; --
gt; Humpy
gt; ------------------------------------------------------------------------
gt; Humpy's Profile: www.excelforum.com/member.php...oamp;userid=31895
gt; View this thread: www.excelforum.com/showthread...hreadid=516342
gt;
gt;

gt; Is there a formula I can use so that cell F2 turns red once we've
gt; passed the due date.

Presume col F = due dates and we have in F2: =A2 E2,
F2 copied down to say, F10
(your : =SUM(A2 E2) can simplified to: =A2 E2)

To apply the cond format to the range F2:F10:

Select F2:F10 (F2 active)
Click Format gt; Conditional Formatting
Under Condition 1, make the settings as:
Formula is: =AND(F2lt;gt;quot;quot;,F2lt;TODAY())
Click Format button gt; Patterns tab gt; Red gt; Font tab gt; bold/white gt;OK
Click OK at the main dialog

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Humpyquot; gt; wrote in
message ...
gt;
gt; Can you help!
gt;
gt; I have set up an Excel spreadsheet as follows:
gt;
gt;
gt; A B C D
gt; E F
gt; 1 DATE NAME INVOICE AMOUNT TERM DUE
gt; DATE
gt;
gt; 2
gt; =SUM(A2 E2)
gt;
gt; 3
gt;
gt; 4
gt;
gt; 5
gt;
gt;
gt; Is there a formula I can use so that cell F2 turns red once we've
gt; passed the due date.
gt;
gt;
gt; --
gt; Humpy
gt; ------------------------------------------------------------------------
gt; Humpy's Profile:
www.excelforum.com/member.php...oamp;userid=31895
gt; View this thread: www.excelforum.com/showthread...hreadid=516342
gt;
Correction, line:
gt; Formula is: =AND(F2lt;gt;quot;quot;,F2lt;TODAY())

should read:
gt; Formula is: =AND(F2lt;gt;0,F2lt;TODAY())
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---