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%





In article ,
(Rob B) wrote:

Quick question. I have a Workbook that essentially references
information from other workbooks. The cell formula is
='[B-Hull_Roadmaps.xls]Revenue'!B12 and it returns a value of 107%
(with the data right now). I want to conditionally format it green
over 100 and red below. It is not working. How do I do this?
Thanks,

Rob