Conditional Formatting

[ads_1471]

I have a spreadsheet where in Column C the CELLs are filled with a mixture of text and numbers.

I am wanting he text to highlight in a colour when text is entered and the numbers to remain black.

Example

Column C3 has Email typed - This would turn red.
Column C4 has a number - 1234 - This would remain black

Chees

 

[Steve Swift]

Hi,

Go to cell C1 and from the home tab in excel click on Conditional Formatting > Highlight Cell Rules > Text That contains

Then enter @ in the box and choose Red Text from the dropdown and click OK

Now select cell C1 and click format painter, then select Column C which will paste the format in all of that column.

Now whenever the @ sign appears in any cell in column C it will be red.

 

[ads_1471]

Hi,

Go to cell C1 and from the home tab in excel click on Conditional Formatting > Highlight Cell Rules > Text That contains

Then enter @ in the box and choose Red Text from the dropdown and click OK

Now select cell C1 and click format painter, then select Column C which will paste the format in all of that column.

Now whenever the @ sign appears in any cell in column C it will be red.

Hi. Unfortunately this ha not worked for what I want.

If I do the @ then that does not search any text I enter and turn it red as opposed to keeping and number black

 

[Steve Swift]

Hi. Unfortunately this ha not worked for what I want.

If I do the @ then that does not search any text I enter and turn it red as opposed to keeping and number black

... You had not mentioned a search feature in your original post?

Are you saying that you want to search for all fields in C column and only then have the ones with the @ sign return as red?

What I suggested will make new or existing data show as red if it contains the @ sign (at least it works for me)

 

[ads_1471]

Hi

What I am saying is. If the below are in CELLs in column C. Then any words will be red and any numbers are black
CEL C2 - Break
CEL C3 - Unit
CEL C4 - 1245
CEL C5 - 2654
CEL C6 - REAL

So all text CEL are red. All numbered are black

 

[Steve Swift]

My mistake, I thought you were asking specifically for cells that contain emails.

In this case I dont think its going to be possible if this is an existing workbook because all of the cells are most likely going to be already formatted as general format. If you are adding data to a new workbook then you could format each cell in Column C as you go along to be a number or text and then apply conditional formatting to get the color.

maybe someone else has a solution but thats all Ive got

 

[Fluff]

Select col C > in CF > New Rule > Use a formula > =ISTEXT(C1) then select the format you want > OK.

 

[ads_1471]

Thank you It has worked

 

[Fluff]

Glad we could help & thanks for the feedback