Conditional Formatting with Function

[Keshypops]

Good Day

I have the below formula in my excel file, i would like to add conditional formatting as follows; between 0% & 29.99% (Red); Equals to 30% (Yellow); Greater than 30% (Green).

The problem i am experiencing is that the blank cells also change green with the conditional formatting, and i do not want to remove the formula.

=IF(ISERROR(F3/E3),"",(F3/E3))

Please Help.

Thanks.

[BadlySpelledBuoy]

Try using AND in your conditional formatting formula

=AND(A1<>"",YourFormula)

Amend A1 to suit.

BSB

[Keshypops]

Hi

Thanks for the help, though i am still confused, if i use your solution what will i use instead of A1? Any of my selections change the cell to true.

All i want is for the conditional formatting to not pick up the blank cells and change the colour.

[BadlySpelledBuoy]

Could you post your workbook? Desensitize any data if necessary.

BSB

[Keshypops]

Hi

File attached

[BadlySpelledBuoy]

In the attached I've changed the conditional formatting for the green from a "cell value > 0.3" to a formula specified condition using the below:

Please Login or Register  to view this content.

Does that help?

BSB

[Keshypops]

Works Perfectly.

Thank You.

[BadlySpelledBuoy]

Happy to help.
Thanks for the rep point

BSB