Hide / unhide columns without using macros / VBA

[sharshra]

I have a simple requirement where I have to hide or unhide few columns based on cell value. I understand this can be done using VBA code. But wanted to know if it can be done using formula without using VBA code or recording a macro.

I´m looking for something like this to be done using formula & without using VBA -

Hide column D to F

If C3 = True
    Unhide column D
    <do something...>
Else Hide column D
End If

If C4 = True
    Unhide column E
    <do something...>
Else Hide column E
End If

If C5 = True
    Unhide column F
    <do something...>
Else Hide column F
End If

RLM - user group access rights.xlsx
	B	C	D	E	F
2	#	True / False
3	1	TRUE	o
4	2	FALSE	n	t
5	3	FALSE	e	w	t
6				o	h
7					r
8					e
9					e
Sheet4

Cell Formulas
Range	Formula
B3:B5	B3	=ROW()-2

 

[JEC]

You can't with formula's. Only option besides VBA is Office scripts