Home

if then formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-615923%22%20slang%3D%22en-US%22%3Eif%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615923%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20some%20formula%20help%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20E2%20%3D%20yes%20then%20F2%20%3D%20N%2FA%20and%20if%20E2%20%3D%20no%20highlight%20F2%20bright%20yellow.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-616426%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-616426%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345105%22%20target%3D%22_blank%22%3E%40folsom1%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20mean%20what%20in%20F2%20is%20already%20some%20value%20and%20you%20substitute%20it%20on%20N%2FA%20depends%20on%20condition%20or%20keep%20as%20it%20is%20and%20highlight%20based%20on%20another%20condition%20-%20that's%20VBA%20programming.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20in%20F2%20the%20formula%20returns%20N%2FA%20or%20empty%20string%2C%20you%20may%20combine%20IF()%20and%20conditional%20formatting.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
folsom1
Occasional Visitor

Looking for some formula help  

What I want to do:

 

IF E2 = yes then F2 = N/A and if E2 = no highlight F2 bright yellow.   

1 Reply

@folsom1 , if you mean what in F2 is already some value and you substitute it on N/A depends on condition or keep as it is and highlight based on another condition - that's VBA programming.

 

If in F2 the formula returns N/A or empty string, you may combine IF() and conditional formatting. 

Related Conversations
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies