Hello, Inquiring if possible to enter a formula that applies to a range of cells if it finds a certain word(s) - to then strike through that word? This is involving two columns of data. i.e. 1st column has a list of Services and the 2nd column has a list of Services that are staying. where would I enter the formula If I want it to find the word "checkin" in both columns (1&2) and then strike through it in the first column only (if possible). This is using Google Sheets, but assuming similar to Excel formula.
Or another way or asking is if I enter the word "checkin" in the 2nd column, can a formula be entered to find "checkin" in the first column and strike through that word?
Hoping that makes sense.
Thanks in advance!
Or another way or asking is if I enter the word "checkin" in the 2nd column, can a formula be entered to find "checkin" in the first column and strike through that word?
Hoping that makes sense.
Thanks in advance!