Editing xls is fast and simple using DocHub. Skip installing software to your PC and make adjustments using our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send documents for completion to other people. All of this, put together with a competing cost, makes DocHub the ideal choice to strike out caption in xls files with ease.
Make your next tasks even easier by turning your documents into reusable web templates. Don't worry about the safety of your information, as we securely keep them in the DocHub cloud.
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