Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional Formatting Pbm | Excel Worksheet Functions |