Editing spreadsheet is fast and simple using DocHub. Skip downloading software to your computer and make adjustments with 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 capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competitive cost, makes DocHub the ideal choice to strike out caption in spreadsheet files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the security of your data, 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