[Solved] Conditional formatting on two whole columns

[hannihannelora]

Hi,

I want the cells of column B to become red if the number in the cell do not mach the number in the cell from the same row in column A.

Is this possible without doing the conditional formatting on every cell on column B separately? (For ex. like this A2:A10 equal to B2:B10)?

[FJCC]

Select all of the cells in column B that you want to affect, say B1:B100. Notice which cell the cursor ends up in. Go to Formatting -> Conditional Formatting and Set up the formula of the conditional formatting as appropriate for the cell that the cursor is in. For example, if you drag down from B1 to B100, leaving the cursor in B100, the formula will be

Code: Select all

B100 <> A100

All of the other selected cells will get a formula of the same type but with the references adjusted for their row.

[robleyd]

Try formatting the first cell, B1, using relative notation - type A1 into the field rather than clicking on A1 - and then either drag B1 down as far as you nee, or use the format paintbrush to copy B1 down as far as you need.

[hannihannelora]

Select all of the cells in column B that you want to affect, say B1:B100. Notice which cell the cursor ends up in. Go to Formatting -> Conditional Formatting and Set up the formula of the conditional formatting as appropriate for the cell that the cursor is in. For example, if you drag down from B1 to B100, leaving the cursor in B100, the formula will be

Code: Select all

B100 <> A100

All of the other selected cells will get a formula of the same type but with the references adjusted for their row.

Thanks. It works really well.