Conditional Formatting?

CTinfojunkie

New Member
I just discovered this forum and I love it! Thanks to all who contribute. I work at a local radio station here in CT. We have local elections coming up next week and I am working on an Excel spreadsheet that we will use to input the data and display it to our anchors and analysts during election night coverage. I am trying to find a way to get Excel to display a check mark or change the color of each winner's name in each race. The only fields I have are candidate name and vote total. Further complicating matters, there can be multiple winners for some races. For example, the top 3 vote-getters our of a slate of 6 may be elected. Would conditional formatting do the job? I would love to hear your suggestions. Thank you in advance!
-CTinfojunkie

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Welcome to the Board!

The easiest/fastest method might be with a combination of Data-->Validation + Conditional Formatting.

Select a blank range of cells in a column to the right of the candidates, then goto Data-->Validation-->Allow-->List-->Source-->"1,2,3" (No spaces or quotes".

You can then select the candiate range and goto Format-->Contitional Formatting-->Formula is-->=\$A1=1 (where \$A1 represents the first Data Validation cell), Format-->Pattern-->Select a color. Add two more conditions, one for =2 and one for =3.

Hope that helps,

Smitty

Welcome to MrExcel Board!

Here's a sample sheet I made:
MainWorkbook.xls
ABCD
1NameVote Total
2John14
3Jim10
4Mary13
5Sue6
6David8
7Lisa11
Sheet2

Using Conditional Formatting in Column B:
FormulaIs:
=AND(RANK(B2,\$B\$2:\$B\$1000)>=1,RANK(B2,\$B\$2:\$B\$1000)<=3)

And adjust your range in Column B, and choose your format. Hope that helps!

EDIT: Smitty beat me to the punch; I had to actually go do some work.

Thanks

Thank you! This helps a great deal. You people know your stuff!

-CTinfojunkie

Replies
3
Views
804
Replies
1
Views
738
Replies
4
Views
213
Replies
6
Views
449

1,203,727
Messages
6,056,970
Members
444,899
Latest member
Excel_Temp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back