I have a spreadsheet, each column is a shop.
Line 3 of each column is the daily target and then lines 5 onwards represent each day of the month where I input the sales.
I have set up conditional format so that if the daily sales is greater than the target, then the cell is coloured green.
How do I, in effect, copy and paste this formatting to every column to save me doing each column individually?
|