View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Valdemar Valdemar is offline
external usenet poster
 
Posts: 1
Default 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