Turning any number caracters Red

[PKFillmore]

Hey. Heres the deal. We receive these 700 page pdf guides that we need to extract into excel.

What I am looking for is a way in excel to change every single number caracter RED without changing the actual number or ,

I want to change the format of each cell to be GREEN IF it contains a number and RED if it does not contain a number.. These "Guides" are like books so there is plenty of paragraphs and sentences that contain numbers..


can anyone help?

Pat

 

[RonB1111]

Use this formula within Conditional Formatting to turn cells green that contain a number. Select the entire worksheet, from the Home ribbon, click Conditional Formatting, New Rule, Use a Formula..., enter the below formula in the box below "Format values where this formula is true":

=OR(ISNUMBER(SEARCH(1,A1)),ISNUMBER(SEARCH(2,A1)),ISNUMBER(SEARCH(3,A1)),ISNUMBER(SEARCH(4,A1)),ISNUMBER(SEARCH(5,A1)),ISNUMBER(SEARCH(6,A1)),ISNUMBER(SEARCH(7,A1)),ISNUMBER(SEARCH(8,A1)),ISNUMBER(SEARCH(9,A1)),,ISNUMBER(SEARCH(0,A1)))

Then click the format icon and in the patterns tab select a green color, then OK

 

[PKFillmore]

THANKS! Your a life saver!

 

[Firefly2012]

An alternative formula might be:

=MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890))<=LEN(A1)

 

[RonB1111]

PKFillmore - You're welcome. Thank you for the feedback.

Firefly - Very clever! I like it. Is the MIN needed, seems to work without it?