Conditional Formatting

[Guest]

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 1>10%
Format RED
15% If 10%<sheet1>15%
Format GREEN
30% If 15%<sheet1>40%
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

 

[David Biddulph]

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%<sheet1>15%

 

[Guest]

Thank you - I could use a help collum, but my data on sheet1 is 36 collums by
2253 rows so it is quite a large data set (which changes). But yes, I could
copy it over, and just hide the rows and collums.

And yes, it looks like I got the >< a bit confused

Thanks for the response