hi can anyone help me show formula in excel....let say
01258
74125
85644
74581
i got this number in one chart,i want use formula in excel to indentify outside from this number,answer is 3 and 9.
1) anyone can show me in excel what formula should i use
2) how use to colour in red
01258
74125
85644
74581
target number 5.this number must highlight in the box as example shown.
what formula should i use?
thanks in advance
01258
74125
85644
74581
i got this number in one chart,i want use formula in excel to indentify outside from this number,answer is 3 and 9.
1) anyone can show me in excel what formula should i use
2) how use to colour in red
01258
74125
85644
74581
target number 5.this number must highlight in the box as example shown.
what formula should i use?
thanks in advance