Conditional formatting
 

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?

Conditional formatting
 

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

Conditional formatting
 

How about copy the cell that has the conditional formatting in.

Go to the destination cell, right click paste special format OK.

Any help?


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539122

Conditional formatting
 

Thanks for the input, but that wouldn't work because the conditional
formatting in the first column is based on the cell value. when you
copy paste special formats the conditional formatting will evaluate the
values in the new column, consequentyly the two columns will not be
color coded the same.

Conditional formatting
 

Use a formula that anchors the column in both columns:

In C2:
=$a2=6

The row will vary with the selection, but the column reference won't change.

JG wrote:

Thanks for the input, but that wouldn't work because the conditional
formatting in the first column is based on the cell value. when you
copy paste special formats the conditional formatting will evaluate the
values in the new column, consequentyly the two columns will not be
color coded the same.

--

Dave Peterson

Conditional formatting
 

Thanks Dave. This is the solution. I don't know why i didn't realize
that earlier.

Conditional formatting
 

Thanks Dave. This is the solution. I don't know why i didn't realize
that earlier.

Conditional formatting
 

Thanks Dave. This is the solution. I don't know why i didn't realize
that earlier.

Conditional formatting
 

Thanks Dave. This is the solution. I don't know why i didn't realize
that earlier.

Conditional formatting
 

I'm glad^4 that you got it working.

JG wrote:

Thanks Dave. This is the solution. I don't know why i didn't realize
that earlier.

--

Dave Peterson