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

 

[Fluff]

Conditional formatting cannot hide columns, just change the way they appear.
To hide them you would need to use VBA.

 

[Joe4]

Note that Conditional Formatting can only format cells, it cannot hide rows or columns

So what exactly do you mean by "hide"?
Do you simply mean make the entry in columns B and D not visible (i.e. change the color of the text in these cells to white so that it matches the color of the background)?

Also note that you cannot hide columns by row. It is an all or nothing proposition. You can only hide the entire column for ALL rows, or for no rows at all.

 

[JOEE1979]

Conditional formatting cannot hide columns, just change the way they appear.
To hide them you would need to use VBA.

Ok, Would you be able to wirte a VBA for me?

 

[JOEE1979]

Note that Conditional Formatting can only format cells, it cannot hide rows or columns

So what exactly do you mean by "hide"?
Do you simply mean make the entry in columns B and D not visible (i.e. change the color of the text in these cells to white so that it matches the color of the background)?

Also note that you cannot hide columns by row. It is an all or nothing proposition. You can only hide the entire column for ALL rows, or for no rows at all.

Would I be able to hide the entire row?

 

[Joe4]

Would I be able to hide the entire row?

Sure. You could even just use Filters to do that, and avoid VBA altogether.

 

[Joe4]

Filtering column C with a Number filter like this would work to filter zeroes and blanks:

 

[JOEE1979]

Filtering column C with a Number filter like this would work to filter zeroes and blanks:
View attachment 90857

Ive never seen this, How would I access this page?

 

[Joe4]

Select the range you want to appy the filters to.
Then, click on the drop-down arrow in the first row on column C.
Then, select the "Number Filters" option and choose "does not equal".

 

[JOEE1979]

The numbers in column "C" are being copied from a different worksheet and change on a daily bases.
How would I be able to have the rows constantly hide/unhide on their own.
Even if they dont hide, but rather change the format to a white font and that way they cant be seen