Highlight numbers repeating more than 3 times
 

Hi
I need to highlight the numbers occuring more than 3 times in a range of
numbers

Highlight numbers repeating more than 3 times
 

1. Select the cell/Range. Please note that cell A1 is the active cell in the
selection range which is used in the below formula.. (Active cell will have a
white background even after selection)

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF($A$1:$J$10,A1)3

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Asoka Walpitagama - Brandix College IT" wrote:

Hi
I need to highlight the numbers occuring more than 3 times in a range of
numbers

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

Highlight numbers repeating more than 3 times
 

THANKS BUDDY

IT WORKED - PERFECT

Rgds

"Jacob Skaria" wrote:

1. Select the cell/Range. Please note that cell A1 is the active cell in the
selection range which is used in the below formula.. (Active cell will have a
white background even after selection)

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF($A$1:$J$10,A1)3

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Asoka Walpitagama - Brandix College IT" wrote:

Hi
I need to highlight the numbers occuring more than 3 times in a range of
numbers