I'm trying to apply conditional formatting a number of rows using a formula.
The formula looks like this:
=NOT(ISBLANK(J20)) which applies to cell F20
I now want to fill down this conditional formatting so that =NOT(ISBLANK(J21)) applies to F21 and so on. However, when I try to do that, the formula keeps refering to J20 even though the reference isn't absolute.
I've tried using the Format Painter - and that works for a single cell which is great. However, when I apply it to all the cells at once it keeps refering to the first cell (J20). How can I avoid that?
Screenshots:
The formula looks like this:
=NOT(ISBLANK(J20)) which applies to cell F20
I now want to fill down this conditional formatting so that =NOT(ISBLANK(J21)) applies to F21 and so on. However, when I try to do that, the formula keeps refering to J20 even though the reference isn't absolute.
I've tried using the Format Painter - and that works for a single cell which is great. However, when I apply it to all the cells at once it keeps refering to the first cell (J20). How can I avoid that?
Screenshots:

