Conditional Formatting Date
 

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

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

Conditional Formatting Date
 

Sorry that should of been =f2<a2.

"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

Conditional Formatting Date
 

Is there a formula I can use so that cell F2 turns red once we've
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 Conditional Formatting
Under Condition 1, make the settings as:
Formula is: =AND(F2<"",F2<TODAY())
Click Format button Patterns tab Red Font tab bold/white OK
Click OK at the main dialog

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Humpy" wrote in
message ...

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

Conditional Formatting Date
 

Correction, line:
Formula is: =AND(F2<"",F2<TODAY())

should read:
Formula is: =AND(F2<0,F2<TODAY())
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---