Simple Shit
Hey, ever have your spreadsheet looking like this?
Wanna hide them zeros??? Would you usually just set conditional formatting to turn the text white if the cell=0? Okay cool but you know weirdly printers like to print those 0 even if they're white so it looks a bit shitty when you print it off, and what if you want to make it pretty (get your shit together and format like this for accesibility and easy reading) like...
Then what? Make separate cond format for each other row? NO FUCK THAT. TRY THIS.
Go to "Custom" in the number formatting and type in the box ";;;" (that's three semi-colons).
And it will hide any text in the cell if it meets the right requirements.
❤ ~~ three semicolons my beloved ~~ ❤
BOOM. GOodbye ugly zeros.
YOU GOT THIS :: Follow for more !!