doesn't contain

Hello, I was wondering if there was a way to make a conditional format that contains any form of text other than "0" will fill the cell the color red and pull information from different sheets in the same workbook in excel. I want "0" to be no color fill. Thank you!