Unconditional formatting not colouring the cells and not copying across

Steve36 · #1 11-23-2020, 04:10 PM

Please help,

Having problems with my conditional formatting

On Cell F3, I've tried everything and not sure why it does not work.
I want it to change the colours of 11 columns below and then.

I also want to copy the Cell across, but its not allowing me.

For it to work in the F3 column, Change Span, Cat and it will change colour but does not work when I copy it across.

Please help

Attached spreadsheet

Greatful for the help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2016 mac text not colouring propperly	GAMIE64	Word	1	04-29-2016 06:18 AM
Copying Same Value Between Two Cells	rsrasc	Excel Programming	3	02-29-2016 10:53 PM
Copying text into multiple cells at once	BIMwit	Word Tables	1	05-14-2015 09:50 PM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Copying cells	isminoh	Excel	5	04-18-2012 11:49 AM