I have a sheet called "Test". Column B shows dynamic API calls, then I use a macro to copy all cells from Column B to Column C every 1 hour in order to store those prices, however sometimes API call fails, so it shows 0. I want to mass replace all cells containing "0" (match exact case) from all columns of sheet "Test" without changing Column B (which is the column for the API calls so we don't want to change its formula). How can I do that? Thank you!

CodePudding user response：

Google sheets doesn't have this function yet but this could do the trick:

1. Select all cells (Ctrl A) click Format > Conditional Formatting

2. Use the dropdown to select Equal To and type 0

3. Tick the text tickbox and change the text color to white, this will effectively hide all your zero values.

CodePudding user response：

You can define a format as

0;-0;