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