Condition format

[alliswell]

hi
i have a range from a3:j150. i have some formulas in cells which are not visible. i want is whenever i put data in cells and complete that row data, my that particular row must get all borders. and whenever i fill cells further, that particular row must get all borders.

for example i put data in a3:j3 then that row must get filled with borders rest rows without borders. now i put data in a5:j5 then my this row must get filled with borders.

and sir why my excel filename shows [group] at the end of filename ? and all my data validation bar doesnt gets highlighted.

thanks and regards

 

[Sam_D_Ben]

Hey,

I guess your workbook is shared which is why the file name showing [Group] and could be the reason for some features might become grayed out

And for borders, Please try this:

 

[Peter_SSs]

why my excel filename shows [group]

That would normally indicate that you have more than one worksheet selected at the same time.

 

[alliswell]

That would normally indicate that you have more than one worksheet selected at the same time.

Ok ok. Got it mr peter. Thanks a lot