| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data in Red and Dark Blue text.
I have a spreadsheet consisting of several thousand lines of data between row
9 and row 9116. Within Column I are monetory amounts in £ sterling. If the amount is greater than £350 it is highlihghted in Red and the breakdown below is highlighted in Dark Blue in units of £350. For example. If the amount is £691.60 the next row down will be £350.00 and the row after that £341.60. How do I cut and paste all the information in Red and Dark Blue text over to a new worksheet in the same workbook? Many thanks for all your help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does the text in some of my cells turn blue? | Excel Discussion (Misc queries) | |||
| Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
| How can I sort data and have the highest value red, 2nd blue, ect | Excel Discussion (Misc queries) | |||
| filtering data and blue marks | Excel Worksheet Functions | |||
| Filter Indicator on Column top should be white, not dark blue | Excel Worksheet Functions | |||
Threaded Mode
