@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.
