conditional format

[JOEE1979]

I want to write a conditional format,

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

 

[Joe4]

For any sort of automation to hide rows, you would need VBA.

To leave the rows there and just hide the text, you can use Conditional Formatting. Here are the steps:
1. Select the rows you want to apply it to (in your example, rows 5-12)
2. Go to Conditional Formatting
3. Select "New Rule"
4. Select "Use a formula to determine which cells to format"
5. Enter the following equation:

=OR($C5="",$C5=0)

(note how the row number in this formula MUST match EXACTLY the row number of the first row selected in step 1)
6. Click on the Format button
7. Go to the Font tab
8. In the Color box, select the white color
9. Click OK

That should do it.

 

[JOEE1979]

work amazing, thanks

 

[Joe4]

You are welcome.
Glad we were able to help!