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