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.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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
7,988
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,671
Messages
5,573,577
Members
412,537
Latest member
Mohamed_5966
Top