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

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" wrote:

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

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

"Sheeloo" wrote:

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" wrote:

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