Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two questions, which I will post separately. Both questions refer to
Excel 2002. Firstly I have a Spreadsheet with entries in cells A1 up to and including AE127. Some of the cells I have made amendments too, and I have changed the colour of the font to red. What I now need to do is to delete any row that does not contain at least one cell that contains €śred text€ť i.e. an amendment. Is this at all possible and preferably NOT using VBA. Is it possible to check the entries on each row and where it finds €śred text€ť on a row to put a number or leave a blank where there are no €śred text€ť entries. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Colour | Excel Worksheet Functions | |||
Changing the colour of text | Excel Discussion (Misc queries) | |||
text colour not kept | Excel Discussion (Misc queries) | |||
Sorting by text colour | Excel Worksheet Functions | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |