People often need to strike out formula in excel when managing forms. Unfortunately, few applications offer the features you need to complete this task. To do something like this normally requires changing between several software applications, which take time and effort. Fortunately, there is a solution that is applicable for almost any job: DocHub.
DocHub is a perfectly-developed PDF editor with a complete set of helpful functions in one place. Altering, approving, and sharing forms gets easy with our online solution, which you can access from any online device.
By following these five basic steps, you'll have your revised excel rapidly. The intuitive interface makes the process quick and effective - stopping switching between windows. Try DocHub today!
The MrExcel podcast is sponsored by Easy-XL. Learn Excel from MrExcel podcast, episode 1917. Formula to Detect Cross out (or any Excel formatting). Hey, welcome back to the MrExcel netcast, Iamp;#39;m Bill Jelen. Back in episode 1538, I showed how to use Conditional Formatting to add diagonal borders, to make it appear that weamp;#39;ve crossed out a cell. And Ahmed just posted a question. And Ahmed just posted a question in response to that video, where he wants to go the opposite way. So, if he would cross out a cell, like for example A1, then another cell, cell B1 would change the message to say: Target accomplished!. So, the question: is there any kind of a function that we can use, like =CROSSEDOUT or =ISCROSSEDOUT, to detect the formula in another cell? No, thereamp;#39;s not. And so I went back to Ahmed and I said: the only way weamp;#39;re going to be able to do this, is with some VBA. And even then itamp;#39;s not going to be perfect. He says: hey, VBA is fine, Iamp;#3
