| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formatting.. how do I copy cells?
I have made a conditional format... changes a cell red after 3 days.. works
great... but when I copy it to the line below.. by dragging or by doing a past special.. it counts from the original date in the 1st line not the second example. a1=06/01/05 a2=06/03/05 cell is red... I drag and drop to cell B1 06/02/05 but cell b2 turns red on 06/03/05 as it is reading date from cell a1... any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
| How to copy conditional formatting | Excel Worksheet Functions | |||
| Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
Threaded Mode
