View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Conditional formatting between worksheets?

Both WBs must be open, and you must assign a name to the cell / range in the
other WB for this to work.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Workaholic" wrote in message
...
I'm trying to change to fill color of a cell in 1 worksheet if the value

of
another worksheet is greater than or equal to a certain value. I'm using
conditional formatting with FormulaIs and the normal If "worksheet cell"
whatever

Help please.

Thanks in advance