Struggling with Excel? How to Highlight Specific Numbers in Your Chart

sunwordelite
Hi, can anyone help me in Excel? What formula should I use if:

457812
852147
458561
147248

I want to identify the numbers outside the chart. The answer is 3 and 9.

1) Which formula should I use? Please teach me.
2) From this chart, I want to target the number as shown below.
Target number: 5
457812
852147
458561
147248

When the target number is input, it should be highlighted in red on the chart.

3) Or should the cell be highlighted in red on the chart? Please teach me. Thank you in advance.

[IMG]https://www.citehr.com/images/misc/progress.gif[/IMG]
Sumalathas
Just check whether the attachment is of any use to you.

---
I have corrected the spelling of "whether" and rephrased the sentence slightly for better clarity.
2 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute