Forum Discussion

folsom1's avatar
folsom1
Copper Contributor
May 20, 2019

if then formula help

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.   

Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 20, 2019

    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.