Thread: Unconditional formatting not colouring the cells and not copying across
View Single Post
 
Old 11-23-2020, 04:10 PM
Steve36 Steve36 is offline Windows 10 Office 2016
Novice
  
Join Date: Nov 2020
Posts: 6
Steve36 is on a distinguished road
Default Unconditional formatting not colouring the cells and not copying across
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
Attached Files
File Type: xlsx Book1.xlsx (9.6 KB, 9 views)