| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Threaded Mode
