Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight numbers repeating more than 3 times
Hi
I need to highlight the numbers occuring more than 3 times in a range of numbers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill reference formula but repeating n times before incrementi | Excel Worksheet Functions | |||
Repeating/incrementing dates 35039 times | Excel Discussion (Misc queries) | |||
How do i use the same name multiple times in repeating worksheets | Excel Discussion (Misc queries) | |||
I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
REPEATING NUMBERS IN A ROW | Excel Worksheet Functions |