vba change cell color if zero

I'm relatively new to working with vba, so this is sort of a stab in the dark.

I have created a userform that inserts user supplied data about into a series of spreadsheets that in turn populate a spreadsheet to keep track of the overall inventory of different parts in our shop.

The overall inventory is populated by countif functions that count the occurence of a type of part. There are several combinations that may never be used and will result in a calculated zero in that cell. These zeros make it hard to read the spreadsheet.

Is there a way I can program the font color or fill color to change if the count value is zero or maybe is greater than zero?

Thanks

Simplest way to suppress display of zero value cells is Tools > Options > View > [ ] Zero values... uncheck that. That setting only applies to the currently active sheet.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.