Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 24th 06, 09:57 PM posted to microsoft.public.excel.newusers
Humpy
 
Posts: n/a
Default 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


  #2   Report Post  
Old February 25th 06, 09:19 AM 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


  #3   Report Post  
Old February 25th 06, 09:22 AM posted to microsoft.public.excel.newusers
TC
 
Posts: n/a
Default 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


  #4   Report Post  
Old February 25th 06, 11:38 AM posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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



  #5   Report Post  
Old February 25th 06, 11:44 AM posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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
---




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enhanced conditional formatting Stuart Excel Discussion (Misc queries) 13 November 13th 05 08:20 PM
Conditional Formatting Dee Excel Worksheet Functions 5 November 3rd 05 11:04 AM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 26th 05 12:50 AM
conditional formatting conflict? Abi Excel Worksheet Functions 2 January 11th 05 04:41 PM
Conditional Formatting (Date vs Number) [email protected] Excel Discussion (Misc queries) 7 December 20th 04 11:23 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017