hi anyone can help me in excel. what formula have to use if
457812
852147
458561
147248
from the chart i want indentify ,outside number from the chart..
answer is 3 and 9
1) what formula should i use .please teach me.
2)from this chart i want target number as example shown below.
target number 5
457812
852147
458561
147248
when target number key in
should be red from the chart.
3)or the cell highlight red colour from the chart..
please teach me thanks in advance...
457812
852147
458561
147248
from the chart i want indentify ,outside number from the chart..
answer is 3 and 9
1) what formula should i use .please teach me.
2)from this chart i want target number as example shown below.
target number 5
457812
852147
458561
147248
when target number key in
should be red from the chart.
3)or the cell highlight red colour from the chart..
please teach me thanks in advance...
[IMG]https://www.citehr.com/images/misc/progress.gif[/IMG]