View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Highlight numbers repeating more than 3 times

Use conditional formatting with a formula condition like:

=COUNTIF(range,cell)3

Hope this helps.

Pete

On Sep 8, 10:27*am, Asoka Walpitagama - Brandix College IT
osoft.com wrote:
Hi
I need to highlight the numbers occuring more than 3 times in a range of
numbers