Computer Related > Excel query - conditional formatting Miscellaneous
Thread Author: Bobby Replies: 1
View Threaded 

New Tue 11 Jul 17 19:38 
 Excel query - conditional formatting - Bobby
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?
Reply to this message | Report message
       
New Tue 11 Jul 17 20:08 
 Excel query - conditional formatting - Bobby
Its ok - got it sussed
Reply to this message | Report message
       
Latest Forum Posts