| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating by truncated values....
I wish to conditionally format a range (say A1:A1000) with the following
criteria; For each cell in the range(A1:A1000), how many of the other cells in that same range, share the first 4 characters - if greater than 1; format....., etc.? I looked at the countif function, but couldn't find a way to apply it and I'm stuck for alternatives..... Any bright ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formating by truncated values....
select A1:A1000 with A1 as the active cell
do format=Conditional Formatting change cell value is to Formula is Enter this formula =COUNTIF($A$1:$A$1000,LEFT(A1,4)&"*")1 click the format button and select the shading. -- Regards, Tom Ogilvy "JB2005" wrote in message ... I wish to conditionally format a range (say A1:A1000) with the following criteria; For each cell in the range(A1:A1000), how many of the other cells in that same range, share the first 4 characters - if greater than 1; format....., etc.? I looked at the countif function, but couldn't find a way to apply it and I'm stuck for alternatives..... Any bright ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formating by truncated values....
Thanks Tom,
So simple when you understand how... ;-) "Tom Ogilvy" wrote: select A1:A1000 with A1 as the active cell do format=Conditional Formatting change cell value is to Formula is Enter this formula =COUNTIF($A$1:$A$1000,LEFT(A1,4)&"*")1 click the format button and select the shading. -- Regards, Tom Ogilvy "JB2005" wrote in message ... I wish to conditionally format a range (say A1:A1000) with the following criteria; For each cell in the range(A1:A1000), how many of the other cells in that same range, share the first 4 characters - if greater than 1; format....., etc.? I looked at the countif function, but couldn't find a way to apply it and I'm stuck for alternatives..... Any bright ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Conditional formating in a List of text and values. | Excel Worksheet Functions | |||
| Conditional Formating Based on Formats Instead of Values | Excel Discussion (Misc queries) | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
Linear Mode
