Conditional Formatting
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
|