Excel query - conditional formatting: Motoring Computer Related forum

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

View Threaded

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

Tue 11 Jul 17 20:08

Excel query - conditional formatting - Bobby

Its ok - got it sussed

Reply to this message | Report message

Forum Version 3.0 - By Khoosys