Hi, I've got 2 columns in Excel. The first has the quantity of an item in stock, the second has the quantity needed for a job. For the second collum, I have conditional formatting so that if the number required is greater than the stock, the cell turns red. And if it is ok (so between 1 & number in stock) then it turns green. Is there a way to copy the conditional formatting to all the other items? At the moment, (using both copy/paste, and the copy formatting brush) it copies the conditional formatting, but references it to the copied item's stock, rather than applying it to the new item's stock.
Solved by X. W. in 17 mins