How to highlight duplicate value by ignoring the formula?

[kimberly090]

I have my excel worksheet.
I wish to highlight the duplicate number which will ignore the formula that I am referring to the last cell.
For example:

I wish to ignore the highlighting in A2 and A3 as they are formula but not value.

 

[VBA Geek]

Select your range and press Control + G, then special >> Constants and click ok

then go to Conditional Formatting > HighLight Cells Rules > Duplicate Value and click ok