Hello helpers!
I need help with a formula and can not seem to get it to work. I think i need to build in and IFERROR formula and can not figure it out.
I have two colums that require a conditional format.
Column M - This is either "Blank" or a capital "X"
Column N - This is a VLookup result so there are "#N/A", The other results are "Completed" "Pending" "Ready" "Dispatched" "Canceled"
The result I am looking for is to highlight the row when:
Column M is "Blank" OR Column N Does not equall "Completed"
Thanks!