Currently Being ModeratedFeb 17, 2013 1:28 PM (in response to rwleejr)
Currently Being ModeratedFeb 17, 2013 1:58 PM (in response to rwleejr)
That sort of test is not supported in Conditional Format. You can test for equal to, less than, greater than and so forth, but you can't do math in the comparison specification, as in your percentage calculation. You can do that calculation in another cell and then compare the cell being formatted to the cell with the calculation.