Conditional formatting border formula

[Jhon Mustofa]

hi all,

I have a list that, how do i create a border that data contains formula (formula not display/blank)...

i want to create dynamic border with condition if data display/showing must be border shown too...

for this, i want to line "TOTAL" in column AD expands up, based on data display/showing...

note : in cell AF2 as parameter/controller to show data by month (type 2 instead February or 3 --March etc...)

please, see my workbook..

any help me will be appreciated...

thanks..

john m

[Jhon Mustofa]

here my file...

[Jhon Mustofa]

hi all, it's possible if using subtotal function then filter/drop list as # 1 post....
but i want how make title "TOTAL" with line expands up depend on display data (neared between last data and data total)...

[Jhon Mustofa]

bump-bump........

[cffndncr]

Tak ngerti lah

You want a border to show if the cell is blank? Use =A2="" in conditional formatting?

[Jhon Mustofa]

the blank cell's display cause formula affect, if use =A2="" it's means, the cell is real blank...but

i want to "total" title, can moving up or moving down depend on data showing....