Copy conditional format
 

I have an inventory that is being done manually with thousands of numbers.
I'd like to be able to identify quantities that haven't changed using a
conditional format. What I don't want is to have to do each cell
individually. Is there any way to set the first cell (Condition 1 (Cell
Value Is equal to =$C$5) then highlight) and then copy each cell below so
that the conditional format also changes? First cell is J5=C5 (highlight)
then J6=C6, etc.

Copy conditional format
 

Select the range of cells to format. Use the Formula Is option and leave the
cell references relative.

Sounds like you want to format column J if the corresponding cell in column
C is equal.

Assume the range is J5:J10
Select the range J5:J10 (so that J5 is the active cell. The active cell is
the one without the "blueish" color)
Conditional Formatting
Formula Is: =J5=C5
Click the Format button
Select the desired style(s)
OK out

The cell references will automatically adjust.

--
Biff
Microsoft Excel MVP


"dodgers32" wrote in message
...
I have an inventory that is being done manually with thousands of numbers.
I'd like to be able to identify quantities that haven't changed using a
conditional format. What I don't want is to have to do each cell
individually. Is there any way to set the first cell (Condition 1 (Cell
Value Is equal to =$C$5) then highlight) and then copy each cell below so
that the conditional format also changes? First cell is J5=C5 (highlight)
then J6=C6, etc.

Copy conditional format
 

dodgers32,

just remove the dollar signs from your cell reference:

change

=$C$5

to

=C5

HTH,

Conan




"dodgers32" wrote in message
...
I have an inventory that is being done manually with thousands of numbers.
I'd like to be able to identify quantities that haven't changed using a
conditional format. What I don't want is to have to do each cell
individually. Is there any way to set the first cell (Condition 1 (Cell
Value Is equal to =$C$5) then highlight) and then copy each cell below so
that the conditional format also changes? First cell is J5=C5 (highlight)
then J6=C6, etc.