Good morning all,

I have a column of numbers from 1 to 10 on a dashboard. On my main worksheet, I have thousands of rows of data, all of which are assigned a number between 1 and 10.

E.g

1 | Apples | Fruit
2 | Apples | Green
3 | Apples | Large
1 | Pears | Fruit
3 | Pears | Small

....etc

However, on occassion, various rows are struck off. This means that often I may have rows that do not contain a specific number. e.g. 7,8,9

I would like my dashboard to highlight the missing numbers by simply conditionally formatting the column.

I'm pretty sure that this would be a formula, such that it would determine the unique numbers, and identify the missing numbers.

Is this possible, and how would it be done?

Help is appreciated.

Cheers!