- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
1
Posted on 7/16/15 at 3:11 pm to bbap
I know you can make it highlight the duplicate numbers, but i'm not sure you can highlight the ones you're trying to highlight.
Posted on 7/16/15 at 3:12 pm to DWaginHTown
Yeah, I'd just treat the 2nd value as a tie and highlight all instances of that value.
Posted on 7/16/15 at 3:13 pm to GetCocky11
no and it changes too.
so what's now:
A1:1
A2:2
A3:3
A4:3
A5:4
in 5 minutes might be:
A1: 10
A2: 12
A3: 11
A4: 12
A5: 13
Initially it would highlight cells A3, A4, and A5. After the data is refreshed it would highlight cells A2, A4, and A5.
So its doing what i want, but each time its highlighting 3 fields instead of just 2. So again its the duplicates issue that I'm facing.
so what's now:
A1:1
A2:2
A3:3
A4:3
A5:4
in 5 minutes might be:
A1: 10
A2: 12
A3: 11
A4: 12
A5: 13
Initially it would highlight cells A3, A4, and A5. After the data is refreshed it would highlight cells A2, A4, and A5.
So its doing what i want, but each time its highlighting 3 fields instead of just 2. So again its the duplicates issue that I'm facing.
Posted on 7/16/15 at 3:13 pm to bbap
Can you format the ranking number cells to no decimals but make the numbers be the result of a formula that where the cells are really
1.0
2.0
3.0
3.1
4.0
If this cell value minus the previous cell value equals zero, add +.1
1.0
2.0
3.0
3.1
4.0
If this cell value minus the previous cell value equals zero, add +.1
This post was edited on 7/16/15 at 3:18 pm
Posted on 7/16/15 at 3:15 pm to GetCocky11
quote:
Yeah, I'd just treat the 2nd value as a tie and highlight all instances of that value.
Well right that is what it's currently doing. That was really the question from the start though. How can i get it to not do that?
again it's not life or death. i just thought there might be an easy formula or an easy path in conditional formatting to take care of this. but it doesnt seem so.
This post was edited on 7/16/15 at 3:16 pm
Posted on 7/16/15 at 3:17 pm to bbap
if you want to highlight just the duplicates in the range of numbers, in Excel 2010, highlight the cells in question, then go to Conditional Formatting - Highlight Cells Rules - Duplicate Values
Posted on 7/16/15 at 3:17 pm to DWaginHTown
quote:
if you want to highlight just the duplicates in the range of numbers, in Excel 2010, highlight the cells in question, then go to Conditional Formatting - Highlight Cells Rules - Duplicate Values
no im trying to highlight the two highest values (excluding any duplicates).
not trying to highlight duplicates.
Posted on 7/16/15 at 3:18 pm to bbap
quote:
Well right that is what it's currently doing. That was really the question from the start though. How can i get it to not do that?
again it's not life or death. i just thought there might be an easy formula or an easy path in conditional formatting to take care of this. but it doesnt seem so.
Unfortunately, I think you are stuck. The only around it, which you said can't be done, is to add another column that can differentiate the values somehow.
Sorry.
Posted on 7/16/15 at 3:19 pm to bbap
I was able to do this.
1
2
3 highlight in purple( dupe value)
3 highlight in red (showing top 2 value)
4 highlight in red (showing top 2 value)
Now, you could change the formatting of the rule and make that purple, normal cell color and that should be what you want right?
1
2
3 highlight in purple( dupe value)
3 highlight in red (showing top 2 value)
4 highlight in red (showing top 2 value)
Now, you could change the formatting of the rule and make that purple, normal cell color and that should be what you want right?
This post was edited on 7/16/15 at 3:21 pm
Posted on 7/16/15 at 3:20 pm to Hogwall Jackson
yeah see my link on the prior page. i did try that. i thought that would do the trick but it didnt for me.
Posted on 7/16/15 at 3:21 pm to bbap
I put the =COUNTIF($A$2:$A2, A2)>1 formula as rule #1 and the top value as rule #2 and its working. I have just the top 2 values highlighting like this.
1
2
3 nothing highlighted
3 red highlight
4 red highlight
It wouldn't work if the formula was rule #2 and the top 2 was rule #1
1
2
3 nothing highlighted
3 red highlight
4 red highlight
It wouldn't work if the formula was rule #2 and the top 2 was rule #1
This post was edited on 7/16/15 at 3:27 pm
Posted on 7/16/15 at 3:22 pm to Hogwall Jackson
quote:
Now, you could change the formatting of the rule and make that purple, normal cell color and that should be what you want right?
yes. post what you did please. nvm see your edit. trying now.
This post was edited on 7/16/15 at 3:23 pm
Posted on 7/16/15 at 3:23 pm to Hogwall Jackson
Nice
Posted on 7/16/15 at 3:26 pm to GetCocky11
lol i must be doing something wrong. it's still highlight 3 cells for me.
got it working. had to do some edited of the dollar signs in the formula.
Thanks man. Appreciate the help.
got it working. had to do some edited of the dollar signs in the formula.
Thanks man. Appreciate the help.
This post was edited on 7/16/15 at 3:28 pm
Posted on 7/16/15 at 3:28 pm to bbap
This post was edited on 7/16/15 at 3:29 pm
Posted on 7/16/15 at 3:30 pm to Hogwall Jackson
Good job 
Posted on 7/16/15 at 3:33 pm to Hogwall Jackson
Posted on 7/16/15 at 3:36 pm to Hogwall Jackson
quote:
I put the =COUNTIF($A$2:$A2, A2)>1 formula as rule #1 and the top value as rule #2 and its working. I have just the top 2 values highlighting like this.
1
2
3 nothing highlighted
3 red highlight
4 red highlight
It wouldn't work if the formula was rule #2 and the top 2 was rule #1
Nice
Page 2 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News