Adding Asterisk symbol to identify significance by formula

[Rashidsharr]

How can we add Aestersk Sign ( * ) in numbers in cell to prove significance. For example in Correlation table we can see correlations numbers but can not identify the significant values by Asterisk* symbol, as we do have in SPSS. Is there any formula in conditional formatting or other tabs?

 

[Andrew Poulsom]

I'm glad you got it working.

I'm not sure what you mean by "I wish to have Asterisk on 1* and 3* like that". Between 1 and 3 is inclusive of 1 and 3 so those numbers should also have an asterisk.

 

[Rashidsharr]

i mean, i got 1*, 2* and 3*; whereas i want only 1* and 3* (Asterisk). Secondly, is there any possibility to have 1 has ONE asterisk and 3 have TWO asterisk like 1* and 3**. Kindest Regards

 

[Andrew Poulsom]

Use the Conditional Formatting rule 'Cell Value equal to'. Have different rules for 1 and 3. For two asterisks use a format like General"**".

 

[Rashidsharr]

Thank you very much indeed. This works for me, awesome.Regards