Joe,

One option would be to set up an equivilent range on your first sheet that
refers to the data on your second sheet via formulas. Then, you can use
conditional formatting because all of your data would be on one sheet.

----
Regards,
John Mansfield


"Joe Gieder" wrote:

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