Forum Discussion
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.
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.