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?