May 20 2019 09:29 AM
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.
May 20 2019 11:27 AM
@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.