That does not seem to work. Nothing happens, the cells remain
normal(white). The cell clearly shows 107% (but I think excel is
looking at the formula instead??). My CF says if cell value =100%
then make it green. The second CF says if it is <100%, make it red.
However, in both cases, nothing happens.

-Rob


JE McGimpsey wrote in message ...
One way:

Say the cell is J1

CF1: Cell Value Is greater than 100%
Format1: green
CF2: Cell Value is less than 100%
Format2: red


The source of the data has no bearing on CF. Note that you've left out
the case where the cell value is equal to 100%