Automatically highlight cells with special characters
 

I need to flag cells that contain numbers with asterixes. Conditional
formatting does not seem to allow this. Is ther any way to automatically
highlight these??

Thanks!
Matt B.

Automatically highlight cells with special characters
 

One possibility would be to concatenate the numbers with an asterisk.

Example: =IF(A1=1,concatenate(A1,"*"),"") where the test value is 1.
Depending on the number of values you want to test for this may be viable.
Or it may not be.

Dave
--
Brevity is the soul of wit.


"Matt B." wrote:

I need to flag cells that contain numbers with asterixes. Conditional
formatting does not seem to allow this. Is ther any way to automatically
highlight these??

Thanks!
Matt B.

Automatically highlight cells with special characters
 

I am not sure that I follow.....

For example, some cells have values of "325" "425" "671" etc
I need the cells with numbers like "987(**)" "999(**)" highlighted.

there are no quotation marks in the cells.

Basically, I transferred some stats over from SPSS and i need to highlight
the significant ones



"Dave F" wrote:

One possibility would be to concatenate the numbers with an asterisk.

Example: =IF(A1=1,concatenate(A1,"*"),"") where the test value is 1.
Depending on the number of values you want to test for this may be viable.
Or it may not be.

Dave
--
Brevity is the soul of wit.


"Matt B." wrote:

I need to flag cells that contain numbers with asterixes. Conditional
formatting does not seem to allow this. Is ther any way to automatically
highlight these??

Thanks!
Matt B.

Automatically highlight cells with special characters
 

Matt

Say it is cells A1:A100 you want to highlight the ones containing an
asterisk, you can use the following formula in conditional formatting:

=SEARCH("~*",A1)

and select the format you wish to apply.

Does this do what you want?

Best regards

Richard


Matt B. wrote:
I am not sure that I follow.....

For example, some cells have values of "325" "425" "671" etc
I need the cells with numbers like "987(**)" "999(**)" highlighted.

there are no quotation marks in the cells.

Basically, I transferred some stats over from SPSS and i need to highlight
the significant ones



"Dave F" wrote:

One possibility would be to concatenate the numbers with an asterisk.

Example: =IF(A1=1,concatenate(A1,"*"),"") where the test value is 1.
Depending on the number of values you want to test for this may be viable.
Or it may not be.

Dave
--
Brevity is the soul of wit.


"Matt B." wrote:

I need to flag cells that contain numbers with asterixes. Conditional
formatting does not seem to allow this. Is ther any way to automatically
highlight these??

Thanks!
Matt B.