I am wanting to create a functionality in my excel document that is like the "if, then" function. Anytime the word "YES" or "NA" appears in a particular set of cells, I would like another series of cells to read "NA" or even be blacked out. Is this possible?
Solved by M. Q. in 20 mins