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.