Conditional Formatting Question

%3CLINGO-SUB%20id%3D%22lingo-sub-1638197%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638197%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20the%20process%20of%20creating%20a%20draft%20board%20for%20my%20upcoming%20fantasy%20football%20draft%20and%20need%20some%20conditional%20formatting%20help.%20The%20link%20to%20my%20sheet%20is%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1Jw6zb3spk_Tq-javfIU63OlwQl1wVkxzSXAP1dMUGXY%2Fedit__%3B!!CBBmrNmIfghdXw!GON7GP5N9iotw4FjA6Rahm2cXPpqAjyvWSOmhgeitP2h1P1yo8nEXYoLVgII7RNp2yeK8e4%24%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1Jw6zb3spk_Tq-javfIU63OlwQl1wVkxzSXAP1dMUGXY%2Fedit%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20color%20code%20players%20based%20on%20their%20position.%20So%20for%20example%2C%20If%20a%20player%20is%20a%20%22RB%22%20I%20would%20like%20the%20cells%20to%20be%20orange.%20So%20with%20Team%201%20in%20Round%201%20selecting%20a%20RB%2C%20I%20would%20like%20cells%20B2%2C%20B3%20and%20C3%20to%20all%20turn%20orange%20automatically%20because%20cell%20C3%20is%20%22RB.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20do%20conditional%20formatting%20to%20fill%20the%20cell%20where%20%22RB%22%20is%2C%20however%2C%20I%20do%20not%20how%20to%20conditionally%20format%20cells%20based%20off%20what%20reads%20in%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1638197%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%3CLINGO-SUB%20id%3D%22lingo-sub-1645880%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783180%22%20target%3D%22_blank%22%3E%40atravalgia11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fconditional-formatting%2Fm-p%2F1638867%23M74133%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fconditional-formatting%2Fm-p%2F1638867%23M74133%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am in the process of creating a draft board for my upcoming fantasy football draft and need some conditional formatting help. The link to my sheet is below.

 

https://docs.google.com/spreadsheets/d/1Jw6zb3spk_Tq-javfIU63OlwQl1wVkxzSXAP1dMUGXY/edit

 

I am looking to color code players based on their position. So for example, If a player is a "RB" I would like the cells to be orange. So with Team 1 in Round 1 selecting a RB, I would like cells B2, B3 and C3 to all turn orange automatically because cell C3 is "RB."

 

I know how to do conditional formatting to fill the cell where "RB" is, however, I do not how to conditionally format cells based off what reads in another cell.

 

Thank you for your help!

1 Reply