- 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
Conditional Formatting question in excel?
Posted on 7/16/15 at 2:05 pm
Posted on 7/16/15 at 2:05 pm
Anyone know how i can highlight the top two values in a range when duplicates are involved?
Say i have a column of these number:
1
2
3
3
4
I want it to highlight the 4 and only 1 of the 3's.
Can't quite figure out how to do that? Anyone know?
Say i have a column of these number:
1
2
3
3
4
I want it to highlight the 4 and only 1 of the 3's.
Can't quite figure out how to do that? Anyone know?
This post was edited on 7/16/15 at 2:05 pm
9
Posted on 7/16/15 at 2:06 pm to bbap
Doesn't stand out as doable without simulating conditional formatting using vba
Posted on 7/16/15 at 2:11 pm to Swoopin
quote:
Doesn't stand out as doable without simulating conditional formatting using vba
Was coming to say vba script and hard code the omission of the 3 you don't want to highlight.
WTF you have two 3's for fricker?
You can also conditionally format that off of a hidden column that has the values + 'a' or something behind that 3.
Posted on 7/16/15 at 2:11 pm to bbap
you will need a more specific criteria to make this happen
can you use a different column?
can you use a different column?
Posted on 7/16/15 at 2:12 pm to bbap
Do you even ctrl-f bro?
Posted on 7/16/15 at 2:13 pm to mikelbr
Based on responses it seems like it's more work than it's worth. It's nothing for work work. I was just trying to make something look a little nicer.
Thanks.
Thanks.
Posted on 7/16/15 at 2:15 pm to bbap
quote:
Conditional Formatting question in excel?
No I don't have any questions, thanks for asking.
Posted on 7/16/15 at 2:30 pm to CaptainsWafer
quote:
No I don't have any questions, thanks for asking
I do. I am looking to highlight two values, but I want to use conditional formatting instead of Ctrl+f because I hate taking the easy way out in life.
Posted on 7/16/15 at 2:33 pm to bbap
A workaround could be to just remove the duplicates, (data ribbon), then do your conditional formatting.
Posted on 7/16/15 at 2:35 pm to bbap
quote:
Based on responses it seems like it's more work than it's worth. It's nothing for work work. I was just trying to make something look a little nicer.
Conditional formatting isn't more work than its worth. Just create another column to help differentiate the 3 values.
Or, if it is listed that way, tell conditional formatting to highlight everything greater than row X
This post was edited on 7/16/15 at 2:36 pm
Posted on 7/16/15 at 2:39 pm to bbap
Yeah, it's been mentioned already put another value in the same row in a column that you hide and base your conditional formatting on the hidden column.
Posted on 7/16/15 at 2:47 pm to UserName69
quote:
I do. I am looking to highlight two values, but I want to use conditional formatting instead of Ctrl+f because I hate taking the easy way out in life.
I dont think you know what you are talking about. I'm not trying to search for anything.
Posted on 7/16/15 at 2:49 pm to jrodslu
quote:
Yeah, it's been mentioned already put another value in the same row in a column that you hide and base your conditional formatting on the hidden column.
i cant edit the data at all. it's being pulled from somewhere else and it changes every 5 minutes or so.
so in theory the two worst scores now might not be the two worst scores in 5 minutes.
Posted on 7/16/15 at 2:50 pm to bbap
quote:
i cant edit the data at all. it's being pulled from somewhere else and it changes every 5 minutes or so.
so in theory the two worst scores now might not be the two worst scores in 5 minutes.
What makes the 3 scores different from each other? Why aren't they being treated as the same?
Posted on 7/16/15 at 2:53 pm to GetCocky11
sorry didnt really understand your question.
Posted on 7/16/15 at 3:05 pm to bbap
You said you only wanted to highlight 1 of the 3s. Why only 1, why not all the 3s? What makes the 3s different?
Posted on 7/16/15 at 3:07 pm to GetCocky11
Nothing makes them different. But i only want the highest two values highlighted at all times. The 4, and just one of the 3s. It makes no difference which one gets highlighted, as long as its just one of them.
This post was edited on 7/16/15 at 3:08 pm
Posted on 7/16/15 at 3:08 pm to bbap
I assume you already tried to conditionally format with top 2 values then remove the dupes? But you're actually wanting to keep the dupes in the data but only highlight 1, right?
Posted on 7/16/15 at 3:09 pm to Hogwall Jackson
quote:
I assume you already tried to conditionally format with top 2 values then remove the dupes? But you're actually wanting to keep the dupes in the data but only highlight 1, right?
Yes i want to keep the duplicates in the data. I tried a bunch of different rules in conditional formatting and was never able to figure it out.
I'm pretty good in excel, but not the absolute best. So i figured it was possible i was doing something wrong.
Page 1 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News