Home

Excel Formula Question

%3CLINGO-SUB%20id%3D%22lingo-sub-1178272%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178272%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20was%20hoping%20someone%20can%20help%20me%20with%20an%20excel%20formula.%20I%20have%20a%20drop%20down%20list%20in%20column%20E%20with%205%20different%20values.%20I%20would%20like%20each%20value%20to%20have%20a%20corresponding%20affect%20on%20the%20status%20of%20the%20cells%20in%20column%20A.%20For%20instance%2C%20if%20the%20value%20in%20the%20drop%20down%20for%20E6%20is%20Complete%2C%20I%20would%20like%20the%20value%20in%20A6%20to%20turn%20Green%20and%20be%20crossed%20out.%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-1178272%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-1178328%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F561124%22%20target%3D%22_blank%22%3E%40BigErn1175%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20conditional%20formatting%20rule%20with%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3D%24E6%3D%22Completed%22%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eto%20highlight%20A6.%20To%20apply%20the%20cross%20that%20perhaps%20by%20VBA%20programming%2C%20but%20that%20could%20be%20workaround%20as%20a%20pattern%20applied.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20102px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171550i648B3540AC5EC155%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178345%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178345%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%2C%20that%20worked!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178408%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178408%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F561124%22%20target%3D%22_blank%22%3E%40BigErn1175%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I was hoping someone can help me with an excel formula. I have a drop down list in column E with 5 different values. I would like each value to have a corresponding affect on the status of the cells in column A. For instance, if the value in the drop down for E6 is Complete, I would like the value in A6 to turn Green and be crossed out.

 

Thank you for your help!

3 Replies
Highlighted

@BigErn1175 

You may apply conditional formatting rule with formula like

=$E6="Completed"

to highlight A6. To apply the cross that perhaps by VBA programming, but that could be workaround as a pattern applied.

image.png

 

Highlighted

@Sergei Baklan 

Thank you for your help, that worked!

Highlighted

@BigErn1175 , glad to help

Related Conversations
Help with counting formula
AL789 in Excel on
1 Replies
Excel hangs up during execution of any operation
Rohit_Agrawal in Excel on
0 Replies
how to create custom number format permanently
iman89 in Excel on
0 Replies
drop-down list vs if-then vs ??
thetis in Excel on
0 Replies
RTD
adriangray in Excel on
0 Replies
Convert Days to whole months
SPC123 in Excel on
2 Replies