Here is how you get the highlighting done where character is >140

1. Goto new rules in Conditional formatting dropdown

2. Select "use a formula to determine which cell to format"

3. In the edit section under "format value where formula is true" give following:

=len(A1)>140

and then select custom formatting (fill color)

Now simply use format painter option to fill the complete column (all individual cells) with this formatting

*Note I am using Excel 2010

If you want your page to be search engine friendly you have only two options:

1. Change 302 redirect to 301 redirect and pointing it to the correct page.

2. If 301 is not possible then remove the 302 redirect and just keep canonical tag pointing to the correct page

Google is really giving troubles in identifying 301 these days and persists showing old URL's. Here is a suggestion that you can work with:

First make sure that you have 301 redirect all old pages to respective new URLs.

Do a quick check using the Fetch as Googlebot to see the response code of old URLs OR see the cache of old URL's which should show corresponding new URL and its data.

If all is well technically, I recommend that use the remove for Google Index feature of Webmaster tool and remove one of the old URL's that is currently ranking. Monitor the change over a couple of weeks to see if new URL start to appear in rankings or for fluctuations in traffic (for old and new URL from your analytics report)

If this approach works, then repeat it for other URL's.