conditional formatting question
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.
|