Conditional formatting across worksheets?
 

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

Conditional formatting across worksheets?
 

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

Conditional formatting across worksheets?
 

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%