Help with Conditional Formatting

[Legacy 387946]

Good evening Forum!

I downloaded the election data, and I have cleaned it up (or I'm in the process of doing so), but I am wanting to incorporate conditional formatting to highlight winning figures. More specifically, I want to highlight the maximum value of a column in a particular county, and I want that highlight to be red when the Republican candidate won, and blue when the Democratic candidate won. I have attached a screenshot below for reference.

So, I want to conditionally format my Worksheet in such a way that the maximum value (per year, so 2016 election is separate from 2012 election) in the POPULAR column in a particular county is highlighted red when Trump won and blue when Clinton won.

Any help would be greatly appreciated. I know that I'll need to set up a formula for my conditional format, but nothing I've tried has worked.

CPE

 

[Legacy 387946]

Well, crud. My 'insert image' didn't work. The screenshot can be found at the following imgur address: Imgur: The most awesome images on the Internet

 

[Legacy 387946]

OR rather, this image is better, since it has column/row numbers visible. Imgur: The most awesome images on the Internet

 

[Legacy 387946]

I figured it may be easier to just attach my worksheet, but I don't see that I have that option. Is there anything I can do to make it easier to help with this request?

 

[Legacy 387946]

I'm pretty sure I need a formula that essentially argues the following: IF the value within a particular range is the maximum value of that range, AND if the text value in column A of the row in which the maximum value exist is, say, "REP.", highlight red. I don't mind setting up two conditions.

 

[Matt Rogers]

Sorry,
Problems with formula ...

 

[Matt Rogers]

Hi.

Excel Workbook
	A	B
1	State	%
2
3	Arizona
4	Clinton	44.0%
5	Trump	47.0%
6
7	Maryland
8	Clinton	63.0%
9	Trump	27.0%
10
11	Oklahoma
12	Clinton	30.0%
13	Trump	60.0%
14
15	Texas
16	Clinton	39.0%
17	Trump	48.0%
18
19	Washington
20	Clinton	50.0%
21	Trump	36.0%
Sheet2

1. Formula is
= AND (A4 = "Trump", B3 < B4 )

2. Formula is
= AND (A4 = "Clinton", B4 > B5)

Formulas wihtout spaces!