Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
Hello,
I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value. The problem is that the values are dynamic and may not always be the same number of occurences, in the same cell, etc. I have used the formula IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the occurences but creating a conditional format has proven out of my league! The way the spreadsheet is designed, the probability of more than 4 IDs being used at any given time is slim, so the next time IDs are input, they can use the same four colors because they will replace the previous IDs. I'm just not sure how to word the conditional format to identify which values are repeating and which are unique and color appropriately. Please help! And thanks!! *This is a repost from 3/31/10 where an answer was never attained. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
is this what you're up to?
select any cell in your range and set the following: 1. condition: =COUNTIF($F$3:F3,F3)=1 and set your formatting for uniques 2. condition: =COUNTIF($F$3:F3,F3)1 and set your formatting for repeating values copy the cell-select other cells-pastespecial-Formats On 21 Kwi, 14:46, andiam24 wrote: Hello, I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value. The problem is that the values are dynamic and may not always be the same number of occurences, in the same cell, etc. I have used the formula IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the occurences but creating a conditional format has proven out of my league! The way the spreadsheet is designed, the probability of more than 4 IDs being used at any given time is slim, so the next time IDs are input, they can use the same four colors because they will replace the previous IDs. I'm just not sure how to word the conditional format to identify which values are repeating and which are unique and color appropriately. Please help! And thanks!! *This is a repost from 3/31/10 where an answer was never attained. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
Thanks for the response; I tried the formatting and it worked to identify
unique versus repeating values. However, I would like for the formatting to apply to all similar values, distinguishing between the varying unique values (see below). QC0094 (green) QC0095 (blue) QC0095 (blue) QC0100 (purple) QC0100 (purple) QC0100 (purple) QC0102 (red) QC0102 (red) "Jarek Kujawa" wrote: is this what you're up to? select any cell in your range and set the following: 1. condition: =COUNTIF($F$3:F3,F3)=1 and set your formatting for uniques 2. condition: =COUNTIF($F$3:F3,F3)1 and set your formatting for repeating values copy the cell-select other cells-pastespecial-Formats On 21 Kwi, 14:46, andiam24 wrote: Hello, I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value. The problem is that the values are dynamic and may not always be the same number of occurences, in the same cell, etc. I have used the formula IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the occurences but creating a conditional format has proven out of my league! The way the spreadsheet is designed, the probability of more than 4 IDs being used at any given time is slim, so the next time IDs are input, they can use the same four colors because they will replace the previous IDs. I'm just not sure how to word the conditional format to identify which values are repeating and which are unique and color appropriately. Please help! And thanks!! *This is a repost from 3/31/10 where an answer was never attained. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |