Text Colour
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
|