SOLVED

Help with Conditional Formatting

Copper Contributor

I have a table that also has a design. It gets stats/numbers from another table and calculates them on this one. Some cells are 0. I'd like to not show those, I was thinking of doing conditional formatting to change the colors of all cells that are 0 but I'm not sure how to with the rows having 2 different colors.

I tried multiple things but so far it hasn't worked.

1 Reply
best response confirmed by Pronoia (Copper Contributor)
Solution

@Pronoia 

You may hide zeroes without conditional formatting

- uncheck this setting

clipboard_image_0.png

- or apply custom number format like

General;General;;@

to your cells:

clipboard_image_1.png

 

1 best response

Accepted Solutions
best response confirmed by Pronoia (Copper Contributor)
Solution

@Pronoia 

You may hide zeroes without conditional formatting

- uncheck this setting

clipboard_image_0.png

- or apply custom number format like

General;General;;@

to your cells:

clipboard_image_1.png

 

View solution in original post