I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to programming and another non-programmer may be tasked to maintain this later.
The calculated column has values from -1 through 5 and I want to grey out everything that is less than 1. The "type" of the calculated column is "Number" in Column Settings.
Condition for formatting:
Style to be applied:
I get no result. Same if I change the comparison to be IsNull or anything else. The conditional formatting works fine when I use other columns for the comparison. e.g. Condition for formatting is "Preferred Setting" (a choice column) equals "One-on-one" (one of the choices).
Is there anything special I can do to allow SPD to interpret my Calculated Column and use it for formatting?