L
Legacy 387946
Guest
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
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