Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with formulas
Hi, first time posting here...I am trying to make a cell (A1) with a date in it turn red within say 15 days, and then turn back to the original color when the completion date in cell B1 is inserted. Basically I'm making a training spreadsheet that will show training coming due (with alerts...red color) and training complete dates. I have pretty much figured out how to make A1 turn red within 15 days, but I cannot figure out how to change it back to the original color dependent on cell B1. Any help would be appreciated!! Scott -- tufftoy ------------------------------------------------------------------------ tufftoy's Profile: http://www.excelforum.com/member.php...o&userid=36567 View this thread: http://www.excelforum.com/showthread...hreadid=563137 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Problem (progression in formulas) | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Tricky formulas needed | Excel Worksheet Functions |