How Can I Highlight Specific Numbers in Excel Using a Formula? Seeking Help!

Hi, can anyone help me show a formula in Excel? Let's say:

01258
74125
85644
74581

I have these numbers in one chart, and I want to use a formula in Excel to identify numbers outside of this set, the answer being 3 and 9.

1) Can anyone show me in Excel what formula I should use?
2) How do I use color to highlight in red?

01258
74125
85644
74581

The target number is 5. This number must be highlighted in the box as shown in the example.

What formula should I use?

Thanks in advance.

Just check whether this attached file is of any use to you.

---

Just check whether this attached file is of any use to you.

Hi, can anyone help me with Excel? What formula should I use to identify numbers 3 and 9 from the chart below:

457812
852147
458561
147248

I want to target number 5 as shown in the example below:

Target number: 5
457812
852147
458561
147248

When the target number is entered, it should be highlighted in red on the chart. Can someone please teach me which formula to use for this? Thanks in advance for your help. I appreciate the valuable Excel format you provided, but I am still unable to find the correct formula. Could someone please help by attaching a sample Excel file? Thank you.