A
Asoka Walpitagama - Brandix College IT
Hi
I need to highlight the numbers occuring more than 3 times in a range of
numbers
I need to highlight the numbers occuring more than 3 times in a range of
numbers
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Highlight numbers repeating more than 3 times
J
Jacob Skaria
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 Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A$1:$J$10,A1)>3
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
If this post helps click Yes
selection range which is used in the below formula.. (Active cell will have a
white background even after selection)
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A$1:$J$10,A1)>3
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
If this post helps click Yes
P
Pete_UK
Use conditional formatting with a formula condition like:
=COUNTIF(range,cell)>3
Hope this helps.
Pete
=COUNTIF(range,cell)>3
Hope this helps.
Pete
A
Asoka Walpitagama - Brandix College IT
THANKS BUDDY
IT WORKED - PERFECT
Rgds
IT WORKED - PERFECT
Rgds
Jacob Skaria said: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 Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A$1:$J$10,A1)>3
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
If this post helps click Yes