text string ""

  1. J

    Conditional Format Several Cells Based on Content of Another Cell

    I've searched the stickies and FAQs and haven't found anything -- after 20+ hours of dedicated research I HAVE to ask you folks how to do this... Initially, I was searching for a formula to set the format of Cell H3 if Cell C3 contains "0 - Completed" as a text string. Then if C4 contained "0...
    • JScotty317
    • Thread
    • based on another cell conditional formatting multiple columns one row text string ""
    • Replies: 3
    • Forum: Excel Questions
  2. derek.hughes

    Making cells blank after formula inserted "" text string

    I wrote nested IF formulas and for the "false" result I told it to enter the text string "" so the cell would appear blank. I can filter out those cells as blank, but not sort them. I have tried a copy/paste special (values) and it still leaves something behind that the sort is picking-up. I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top