Hi guys, I've created a little scheduling spreadsheet based in Google Sheets for my work. It allows us to allocate various Trucks and Drivers to jobs. I've got a seperate sheet where I input all the Truck Names and Drivers Names, and each new sheet has all these trucks and drivers listed.
However, I need to seperate the trucks into their vehicle types (van, 3.5t, 7.5t etc) so it's easy to identify what type of truck each registration number refers too. I've tried formatting the cells into different colours depending on vehicle type but when the data is transferred into a sheet it's not copying the formatting.
How can I make it copy the formatting of a cell so it pastes both the value and cell format, not just the value?
My code so far is: =iferror(filter(T2:T,isna(match(trim(T2:T),trim(M7:M),0))))
Which works, but just doesn't copy the cell format.
Cheers!
However, I need to seperate the trucks into their vehicle types (van, 3.5t, 7.5t etc) so it's easy to identify what type of truck each registration number refers too. I've tried formatting the cells into different colours depending on vehicle type but when the data is transferred into a sheet it's not copying the formatting.
How can I make it copy the formatting of a cell so it pastes both the value and cell format, not just the value?
My code so far is: =iferror(filter(T2:T,isna(match(trim(T2:T),trim(M7:M),0))))
Which works, but just doesn't copy the cell format.
Cheers!
