Text Colour

[Chris waller]

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

 

[Sheeloo]

One way is to make a copy of the worksheet
In the copy Find cells with RED FONT then replace by something like ^%^
which is not likely to be part of your values
In AF1 enter
=MATCH("^%^",A1:AE1,0)
and copy down

For those rows without any RED FONT cell you will get #N/A. Copy column AF
choose PASTE SPECIAL|Values onto AF column in your original sheet, filter on
#N/A and delete those rows

 

[Chris waller]

Thanks for the info. I will certainly give it a try.