Use that other cell in the format|Conditional formatting formula.

You can use one cell as the basis for the conditional formatting for a different
cell.

Debra Dalgleish has some notes at:
http://www.contextures.com/xlCondFormat02.html


JG wrote:

I have a column of data in Excel that has conditional formatting, color
filling, based on cell value. I need to highlight a cell, not the
entire row, in another column the same color as the column with the
conditional formatting on it, but the two columns are not mathmatically
related. Suggestions?

--

Dave Peterson