I have put together a simple spreadsheet and in one section i want to highlight values in four columns by filling the cell with colour to determine if the calculated value in either of those columns are higher or lower than a value in another reference column by changing the cell colour to red (higher) or Green (lower).



I have written the conditional formatting okay and it works on the first row of the sheet but when I use format painter to copy it to other cells the cell references and colour do not change their references they are still referencing the first cell in column S rather than the associated row.

For example row 5 cell T5, U5, Z5, AA5 would still reference Cell S4 rather than S5.

Attached Files

Windows dimensions 190429 BA.xlsm (30.5 KB, 7 views)