I want to write a conditional format,
If column "C" is empty or "0" then hide column "B" and column "D"
If column "C" is empty or "0" then hide column "B" and column "D"
MulitpleForm.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Good morning, | |||||||||
2 | ||||||||||
3 | The following inspection buses were released for AM service requirements | |||||||||
4 | ||||||||||
5 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
6 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
7 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
8 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
9 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
10 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
11 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
12 | Unit | 0 | Confirmed compliant for mileage and date | |||||||
13 | ||||||||||
14 | Thank you | |||||||||
15 | ||||||||||
Spare Email |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:C12 | C5 | ='Spare Units'!C6 |