vba change cell color if zero

[jducc]

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

[JBeaucaire]

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.

[jducc]

Easy enough. Thank you.

[JBeaucaire]

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