SOLVED

conditional formatting based upon a comparison of two columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2226965%22%20slang%3D%22en-US%22%3Econditional%20formatting%20based%20upon%20a%20comparison%20of%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2226965%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20organising%20a%20betting%20competition%20in%20our%20office.%20Individuals%20pick%20teams%20they%20think%20will%20win%20in%20a%20head-to-head%20format.%20I'd%20like%20to%20be%20able%20to%20create%20a%20worksheet%20to%20deal%20with%20this%20more%20gracefully.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecifically%2C%20in%20the%20spreadsheet%20attached%2C%20I'd%20like%20to%20compare%20E2%20to%20D2%20(and%20F2%20to%20D2)%20and%20depending%20on%20the%20value%20in%20the%20cells%2C%20change%20the%20formatting%20to%20indicate%20whether%20the%20guess%20was%20correct%20or%20not.%20Is%20this%20the%20best%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20I%20also%20be%20able%20to%20count%20the%20total%20number%20of%20correct%20guesses%20(and%20calculate%20a%20winning%20percentage)%20based%20upon%20the%20method%20above%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2226965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I'm organising a betting competition in our office. Individuals pick teams they think will win in a head-to-head format. I'd like to be able to create a worksheet to deal with this more gracefully.

 

Specifically, in the spreadsheet attached, I'd like to compare E2 to D2 (and F2 to D2) and depending on the value in the cells, change the formatting to indicate whether the guess was correct or not. Is this the best way to do this?

 

Would I also be able to count the total number of correct guesses (and calculate a winning percentage) based upon the method above?

 

Thanks in advance.

3 Replies
best response confirmed by theirlaw (Occasional Contributor)
Solution

@theirlaw Perhaps like in the attached sheet.

 

@Riny_van_Eekelen 

 

that's fantastic thanks so much! I think I should add data validation(?) so that if there's a spelling mistake (like Raiders / Radiers for example) it doesn't break everything.

@theirlaw Adding data validation is always a good idea when you are dealing with features that call for an exact match between pieces of information. Good luck! Glad I could help.