Hi,

let me make it more clear:

my 2 column is like this,

col_a is numbers, col_b is percentage, if cells in col_b bigger than 30%, i
want to change cells in col_a's color to pink.

Would you help me, btw, i am using 2007. thx.

"JLatham" wrote:

If the color in column A is being changed by conditional formatting, set up
the same condition in the column B cell, but referencing column A (use
Formula Is instead of Cell Value Is).

For example, lets say you set up a conditional format for Cell A2 that says
if its value is 5, set the background as Red. Then in B2 we'd set up
conditional format as
Formula Is and enter =$A$2=5 and set the background color to Red also.

"JJ" wrote:

if column_a changes the color, i want column_b change to the same color. how
can i do that? thx.