Highlight all duplicate cells ignoring blank cells

Hii...

I wants to highlight all duplicate values in a column ignoring blank cells or cells containing zero..Tried conditional formatting>Highlight duplicate values but it also highlight all blanks/zero value cells as it considers them to be all duplicates...what is the solution?

Hii..

I have not used formula in conditional formatting to highlight duplicates..its a inbuilt option in conditional formatting to do the same..So how I can use condition if not "" and if <> 0 while highlighting duplicates only..??

Here is how I made Excel duplicate check ignore blank cells. It also
works for ignoring pretty much ANY type of cell value you want to ignore.

This example shows how to make it ignore blank cells:
1. Select the range you wish to highlite dupes, and make the simple dupe rule as usual.
2. Select the same range, and select "Conditional Formatting > Manage Rules".
3. Select "New Rule > Use a formula ...".
4. If (for example) your selected range is "$C$3:$C$12" enter this formula: =C3=""
and then hit "Enter" (you are done! Leave formatting unset!)
5. The new rule will be placed above your older (check duplicate) rule.
Select the "Stop if True" check box to the far right of the new rule.
6. That's it! Done. If the cell is blank, the "check duplicate" rule is ignored.

1. Highlight all duplicates as you normally would
2. Create a new rule to format only cells that contain blanks and apply no formatting to these cells
3. Go to manage rules and for the blanks, check off "Stop if true"

Yay! Just solved this too.

First: Select the column, then go to conditional formatting and select: Format only cells that contain > then choose Blanks (no format set).
Then: Create a new condition back in conditional formatting and select: Format only unique or duplicate values > then choose duplicate (choose the format u want say background yellow)
Finally (very important): Tick the "Stop IF True" next to the first condition: Cell contains a blank value

Hope this helps you too! Let me know