Highlight Differences

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
This should be easy for you experts.

I am in an office football pool and I would like to be able to quickly see who picks the same as me or different.

For instance, If the pick the same as me, highlight their pick in green. If it is different, highlight it red.

Thanks in advance for your help.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
Use conditional formatting.

If your picks are in column A and someone else's picks are in column B:

Set up B1's conditional formatting as: formula is = B1=$A1 as green and/or formula is = B1<>$A1 as red

Copy and paste formats down and across (to other people)
 

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
THIS IS PART OF WHAT I HAVE:
A B C D E F G
Frank Snell Car Mia Pit NyG Chi Bal
Bob Britton Car Mia Cin NyG Chi Bal
Bryant Car Mia Cin NyG Gb Bal
I WOULD LIKE CELLS D2, D3 AND F3 TO BE RED.

I AM NOT FAMILIAR WITH CONDITIONAL FORMATING, PLEASE BE MORE SPECIFIC.

THANKS
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
1) Select cell B2
2) Go to format --> conditional formatting
3) Change "Cell value is" to "formula is"
4) enter =B2<>B$1 next to formula is
5) click Format and change the pattern to red
6) click ok twice

(you could add a condition in the format --> conditional formatting menu and use similar steps to set the pattern to green for formula is B2 = B$1 if you'd like)

Copy B2, select B2:G3, and use edit --> paste special --> formats
 

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
Worked like a champ.

See I told you that would be easy.

Thanks.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,018
Messages
5,834,976
Members
430,331
Latest member
Syed Yasir Hannan

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?

Disable AdBlock

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

Disable AdBlock Plus

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
Top