conditional formatting question

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

if column_a changes the color, i want column_b change to the same color. how
can i do that? thx.
 
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.
 
It is in the drop down list when you first start Conditional Formatting. It
is initially displayed as [Cell Value Is] followed by something like
"between" and a couple of data entry boxes.

Just click the arrow on the [Cell Value Is] and you'll see [Formula Is] and
the rest of the form will change based on that.
 
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.
 
Back
Top