| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
After a cell changes colour when a date is near
When the cell changes to a specific colour say a12 goes red when a date is
within 30 days (a12 is a date an assessment is due) can a12 and a1 (which a persons name is in a1) be put on a different worksheet and the same for each row so i can have a list of names and assessments on a seperate worksheet to print off so it would look like this A N OTHER FDA 02-JAN-06 A BODY SUMMARY 02-JAN-06 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions | |||
| cell color change based on due date | New Users to Excel | |||
| cell color index comparison | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Extract date from cell | Excel Worksheet Functions | |||
Threaded Mode
