Conditional format cells error value

[skoorBmaS]

I currently have a table which has the following formula:

=IFERROR(GETPIVOTDATA("Shift Exceed 12hrs",Pivots!$B$3,"Week",$E$9,"Name",C10),"0")

This makes the cell show 0 if there is an error, which would be caused by no data being populated. However, I would like the cell to be highlighted green if the value is <1. I have a conditional format set up which will do this is the actual value is 0, however if the cell is showing 0 because of an error, then the cell does not get formatted. How can I go about formatting this cell just like the others?

 

[cerfani]

because you are using the string "0" ... that is not a number

use the number 0 when you get an error

you cant check if a string is less than something without converting it to a number first... but you shouldnt use a string to begin with