Spreadsheet: 717584d1612753536-conditional-formatting-multiple-ranges-tabs-conditional-formatting-multiple-rules-referencing-separate-sheet-fayecattini-
Sheet: Data Sheet

ID | Resource Name | Project Name | Activity | Start Date | End Date | Rest Start | Rest End | Project Code
1 | MTCSS 1 | PROJ05310 | BATH ENGLSHCMB LN EXP | 2021-02-01 00:00:00 | 2021-02-12 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | BATH
1 | MTCSS 2 | PROJ08495 | ST AUSTELL 2 | 2021-02-08 00:00:00 | 2021-02-19 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | ST AUS
 | SPRAY 1 | PROJ08496 | ST AUSTELL 3 | 2021-02-08 00:00:00 | 2021-02-19 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | ST AUS
1 | CONTRACT 2 | PROJ05411 | BRENTWOOD [NAME] EXP | 2021-02-08 00:00:00 | 2021-02-12 00:00:00 |  |  | BRENT
1 | CONTRACT 1 | PROJ05245 | ABERDALE RD LEICS EXP | 2021-02-08 00:00:00 | 2021-02-12 00:00:00 |  |  | ABER
1 | MTCSS 1 | PROJ05185 | [NAME] | 2021-02-22 00:00:00 | 2021-02-26 00:00:00 |  |  | ROMS
1 | MTCSS 2 | Proj1525293 | SOUTHAMPTON BUTTS EXP | 2021-02-22 00:00:00 | 2021-02-26 00:00:00 |  |  | SOUTH
1 | MTCSS 1 | Proj1525292 | TAUNTON | 2021-03-01 00:00:00 | 2021-03-05 00:00:00 |  |  | TAUNT
1 | MTCSS 2 | PROJ05267 | CAM-DURSLEY | 2021-03-01 00:00:00 | 2021-03-05 00:00:00 |  |  | CAMD
 | CONTRACT 1 | PROJ05185 | PORTLAND EASTON | 2021-03-01 00:00:00 | 2021-03-05 00:00:00 |  |  | PORT
 | MTCSS 1 | PROJ05267 | STOKENCHURCH EXP | 2021-03-08 00:00:00 | 2021-03-12 00:00:00 |  |  | STOCH
 | MTCSS 1 | PROJ05378 | LAUNCESTON | 2021-04-05 00:00:00 | 2021-04-09 00:00:00 |  |  | LAUNS
 | MTCSS 2 | PROJ05408 | YEOVIL EXTRA | 2021-04-05 00:00:00 | 2021-04-09 00:00:00 |  |  | YEOV
 | CONTRACT 1 | PROJ05115 | TYN Y PARC CARDFF EXP | 2021-04-06 00:00:00 | 2021-04-10 00:00:00 |  |  | TYNY
 | CONTRACT 2 | PROJ05220 | NEWTON ABBOT | 2021-04-06 00:00:00 | 2021-04-10 00:00:00 |  |  | NEWTA
 | MTCSS 1 | Proj1525274 | SOUTHCOTE EXPRESS | 2021-05-17 00:00:00 |  |  |  | SOUTHEXP
 | MTCSS 2 | Proj1525260 | CHESTRTN CIRNCSTR EXP | 2021-05-17 00:00:00 |  |  |  | CHEST
 | CONTRACT 1 | Proj1525002 | PEMBROKE DOCK | 2021-05-17 00:00:00 |  |  |  | PEM
 | CONTRACT 2 | Proj1525068 | SHOREHAM EXTRA | 2021-05-17 00:00:00 |  |  |  | SHORE
 | CONTRACT 3 | Proj1525005 | HELSTON | 2021-05-17 00:00:00 |  |  |  | HELS
 | CONTRACT 4 | Proj1525177 | DINAS POWYS CASTL EXP | 2021-05-17 00:00:00 |  |  |  | DINAS
 | MTCSS 1 | Proj1525135 | BLENHEIM CT BRSTL EXP | 2021-05-24 00:00:00 |  |  |  | BLEN
 | MTCSS 1 | Proj1525008 | LANGPORT | 2021-06-07 00:00:00 |  |  |  | LANG
 | MTCSS 2 | Proj1525180 | SLOUGH BURNHAM RD EXP | 2021-06-07 00:00:00 |  |  |  | SLOUGH
 | MTCSS 1 | Proj1525010 | LLANDRINDOD WELLS | 2021-06-14 00:00:00 |  |  |  | [NAME]
 | MTCSS 2 | Proj1525182 | [NAME] EXP | 2021-06-14 00:00:00 |  |  |  | SALTF
 | CONTRACT 1 | Proj1525012 | HONITON | 2021-06-16 00:00:00 |  |  |  | HONI
 | MTCSS 1 | Proj1525000 | KINGSBRIDGE | 2021-06-21 00:00:00 |  |  |  | KINGS
 | MTCSS 2 | Proj1525013 | CALLINGTON | 2021-06-21 00:00:00 |  |  |  | CALLIN
 | CONTRACT 1 | Proj1525279 | LEYES LN KENLWRTH EXP | 2021-06-21 00:00:00 |  |  |  | LEYES
 | CONTRACT 2 | Proj1525014 | NEWTOWN CATTLE MARKET | 2021-06-21 00:00:00 |  |  |  | NEWTC
 | CONTRACT 3 | Proj1525270 | TUPSLEY EXPRESS | 2021-06-21 00:00:00 |  |  |  | TUPS
 | MTCSS 1 | Proj1525188 | WEST PARLEY EXP | 2021-07-05 00:00:00 |  |  |  | WESTPA
 | MTCSS 2 | PROJ04727 | MAIDENHEAD FURZE EXP | 2021-07-11 00:00:00 |  |  |  | MAID
 | MTCSS 1 | Proj1525342 | WESTWARDHO GLF LK EXP | 2021-07-12 00:00:00 |  |  |  | WESTHO
 | CONTRACT 1 | Proj1525190 | WESTBOURNE POOLE EXP | 2021-07-12 00:00:00 |  |  |  | WESTBO
 | MTCSS 1 | [NAME] | MUTLY PL PLYMOUTH EXP | 2021-08-02 00:00:00 |  |  |  | MUTLY
 | MTCSS 1 | Proj1525031 | CREDITON | 2021-08-16 00:00:00 |  |  |  | CREDI
 | MTCSS 1 | Proj1525205 | CONGRESBURY EXP | 2021-08-23 00:00:00 |  |  |  | CONGR
 | MTCSS 2 | Proj1525033 | KEYNSHAM | 2021-08-23 00:00:00 |  |  |  | KEYNS
 | MTCSS 1 | Proj1525206 | ROGERSTONE NEWPRT EXP | 2021-08-30 00:00:00 |  |  |  | [NAME]
 | MTCSS 1 | Proj1525208 | IVYBRIDGE EXP | 2021-09-06 00:00:00 |  |  |  | IVY
 | MTCSS 1 | Proj1525281 | LINSLADE BUZZRD EXP | 2021-09-13 00:00:00 |  |  |  | LINS
 | MTCSS 2 | Proj1525209 | SWANSEA LANGDN RD EXP | 2021-09-13 00:00:00 |  |  |  | SWANS
 | CONTRACT 1 | Proj1525210 | TWYFORD RD [NAME] EXP | 2021-09-13 00:00:00 |  |  |  | TWYF
 | MTCSS 1 | Proj1525222 | EXWICK EXP | 2021-10-25 00:00:00 |  |  |  | EXWICK
 | MTCSS 1 | [NAME] | NEW CARDINGTON EXP | 2021-11-15 00:00:00 |  |  |  | CARDI
 | MTCSS 1 | Proj1525054 | BRISLINGTON EXTRA | 2022-01-10 00:00:00 |  |  |  | BRIS
 | MTCSS 2 | Proj1525053 | MAESTEG | 2022-01-10 00:00:00 |  |  |  | MAESTEG
 | MTCSS 1 | Proj1525245 | BRNMOUT HOLDEN RD EXP | 2022-01-24 00:00:00 |  |  |  | BRNMOUT
 | MTCSS 2 | Proj1525246 | [NAME] EXP | 2022-01-24 00:00:00 |  |  |  | CHURCH
 | CONTRACT 1 | Proj1525243 | LLANTWIT FARDRE EXP | 2022-01-24 00:00:00 |  |  |  | LLANT