If, Then

%3CLINGO-SUB%20id%3D%22lingo-sub-815337%22%20slang%3D%22en-US%22%3EIf%2C%20Then%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20not%20sure%20what%20I%20am%20doing%20incorrectly%20when%20trying%20to%20do%20conditional%20formatting%3A%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22full_width%22%3E%3CDIV%20class%3D%22inner%22%3E%3CDIV%20class%3D%22content%22%3E%3CDIV%20class%3D%22comment-container%22%3E%3CDIV%20class%3D%22comment_text%22%3E%3CP%3EI%20have%20tried%20with%20full%20columns%20as%20well%20as%20individual%20cells.%20My%20formula%20looks%20like%20this%3A%20%3D%24E%3A%24E%3D%E2%80%9DYes%E2%80%9D%3CBR%20%2F%3Eformat%20grey%3CBR%20%2F%3Eapplies%20to%20%3D%24F%3A%24F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20then%20go%20to%20my%20document%20and%20choose%20Yes%20from%20the%20pull%20down%20menu%20and%20it%20does%20not%20change%20any%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815337%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%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-815755%22%20slang%3D%22en-US%22%3ERe%3A%20If%2C%20Then%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815755%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392942%22%20target%3D%22_blank%22%3E%40analis_yeg%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EAssuming%20your%20data%20starts%20at%20cell%20E1%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3ESet%20your%20formula%20to%20%3DE1%3D%22Yes%22%20and%20apply%20it%20to%20%24F%3A%24F.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20should%20fix%20your%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815958%22%20slang%3D%22en-US%22%3ERe%3A%20If%2C%20Then%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815958%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20what%20my%20formula%20looks%20like%20when%20I%20go%20under%20conditional%20formatting%3A%3C%2FP%3E%3CP%3E%3D%24E%3A%24E%3D%22Yes%22%3C%2FP%3E%3CP%3Eformat%20grey%3C%2FP%3E%3CP%3Eapplies%20to%3A%20%3D%24F%3A%24F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20apply%20this%2C%20nothing%20happens.%20Same%20if%20I%20just%20choose%202%20cells%20as%20opposed%20to%202%20columns...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816021%22%20slang%3D%22en-US%22%3ERe%3A%20If%2C%20Then%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816021%22%20slang%3D%22en-US%22%3EIf%20you%20set%20your%20formula%20as%20%3D%24E%3A%24E%3D%E2%80%9CYes%E2%80%9D%2C%20then%20you%20will%20return%20nothing%20because%20the%20entire%20column%20E%20does%20not%20equate%20to%20%E2%80%9CYes%E2%80%9D.%3CBR%20%2F%3E%3CBR%20%2F%3EInstead%2C%20in%20only%20the%20first%20cell%20of%20which%20you%20would%20like%20to%20apply%20the%20conditional%20formatting%20(i.e.%20cell%20F1)%2C%20set%20the%20conditional%20format%20formula%20to%20%3DE1%3D%E2%80%9CYes%E2%80%9D.%20Then%20in%20the%20%E2%80%9Capplies%20to%E2%80%9D%20section%2C%20select%20F%3AF.%20This%20will%20allow%20the%20conditional%20format%20to%20search%20in%20each%20adjacent%20cell%20for%20the%20text%20%E2%80%9CYes%E2%80%9D.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%2C%20if%20cell%20E1%20holds%20the%20value%20%E2%80%9CYes%E2%80%9D%2C%20then%20cell%20F1%20will%20be%20formatted%20grey.%20If%20the%20cell%20E2%20holds%20the%20value%20%E2%80%9CNo%E2%80%9D%2C%20then%20cell%20F2%20will%20not%20be%20formatted%20grey.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps!%3CBR%20%2F%3EPReagan%3CBR%20%2F%3E%3CBR%20%2F%3E*This%20post%20was%20sent%20via%20mobile%20so%20please%20excuse%20any%20typos%3C%2FLINGO-BODY%3E
analis_yeg
New Contributor

I am not sure what I am doing incorrectly when trying to do conditional formatting:

I have tried with full columns as well as individual cells. My formula looks like this: =$E:$E=”Yes”
format grey
applies to =$F:$F


I then go to my document and choose Yes from the pull down menu and it does not change any cells.

 

Please advise

 

Thank you for your time!

 

A

3 Replies

Hello @analis_yeg,

 

Assuming your data starts at cell E1:

Set your formula to =E1="Yes" and apply it to $F:$F.

 

This should fix your issue.

Here is what my formula looks like when I go under conditional formatting:

=$E:$E="Yes"

format grey

applies to: =$F:$F

 

When I apply this, nothing happens. Same if I just choose 2 cells as opposed to 2 columns...

If you set your formula as =$E:$E=“Yes”, then you will return nothing because the entire column E does not equate to “Yes”.

Instead, in only the first cell of which you would like to apply the conditional formatting (i.e. cell F1), set the conditional format formula to =E1=“Yes”. Then in the “applies to” section, select F:F. This will allow the conditional format to search in each adjacent cell for the text “Yes”.

For example, if cell E1 holds the value “Yes”, then cell F1 will be formatted grey. If the cell E2 holds the value “No”, then cell F2 will not be formatted grey.

I hope this helps!
PReagan

*This post was sent via mobile so please excuse any typos