Copying Conditional Formatting - example.bmp (0/1)

  • Thread starter Thread starter Warhawk
  • Start date Start date
W

Warhawk

I am trying to copy conditional formatting using formula instead of
cell value. I cannot get it to progress down the column. I attached
a file to illustrate.

I have oversimplified the illustration but in it I would like to apply
conditional formatting to column A to highlight the cell in Red if the
number is higher that the cell to it's right in column B.

I create a simple conditional format in A1 that says if A1 is greater
than B1, highlight the cell in Red. That works.

My question is how do I copy that format down the column? I tried
copy and past special and every other technique I can think of to get
the conditional format and every cell gets the reference to B1 in
them. Excel is not spotting my trend and incrementing the B1 to B2 to
B3 etc...

Any help would be massively appreciated!

Government's view of the economy could be summed up in a few short phrases: If it moves, tax it. If it keeps moving, regulate it. And if it stops moving, subsidise it.
Ronald Reagan
 
Select all the cells in column A that you want, and then apply the
conditional formatting.

HTH
Regards,
Howard
 
Back
Top