View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob B[_2_] Rob B[_2_] is offline
external usenet poster
 
Posts: 6
Default 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