Presumably the easiest way is to use a helper column on sheet 2, linked to
the sheet 1 data, then you can use this sheet 2 cell as the reference for
you CF on sheet 2.
I assume that you've got some of your < and symbols confused? For example
I guess you mean If 10%<sheet1<15% not If 10%<sheet115%
--
David Biddulph

"Valdemar" <Valdemar @discussions.microsoft.com wrote in message
...
How do I use conditional formatting between different sheets in the same
workbook?

Example:
Sheet 1 Sheet 2
Sales increase Jan Inventory Decrease Jan
10% If 0<sheet 110%
Format RED
15% If
10%<sheet115%
Format GREEN
30% If
15%<sheet140%
format PINK

I know how to do it if the information is in the same sheet, but they are
not.
If it is not possible to do this by conditional formatting, any other
suggestions? The cell in sheet 2 allready contains an extensive IF
formula,
so preferably without "programming".

Hope it makes sense.

Thank you