| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Format using value from another sheet
Is there a way (formula) to format (highlight) a cell on one sheet with a
value from another sheet? I tried Conditional Formating but it says you cannot use a value from another sheet. If I have: Sheet 1 value to use Sheet 2 cell to color A A B C D on sheet 2 1 3 7 2 1 3 D1 2 4 9 11 4 8 C2 3 2 2 1 6 5 A3 4 8 7 8 3 9 B4 TIA Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
| Conditional format sheet data | Excel Worksheet Functions | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
Threaded Mode
