Condtional Format cells - Format for cells that are not 0%

[MrPink1986]

HI,

I would like to format a number of ranges on my spreadsheet. The format is to be a colour when the value is not 0%. My problem arises that there is a formula in the range and when the format is applied any cells with a formula is applied, I would like the format only to bel applied when there is an actual value and not a formula.

This is the formula I have in my spreadsheet - =IF(A3="","",P3/H3)

Any help greatly appreacited.

Cheers
S

 

[MrPink1986]

You right click, choose Format Cells and on the Number tab select Custom and enter this in the Type box:

0.00%;-0.00%;

Many thanks that has worked a treat - I appreciate your help on this.