Formatting multiple columns of a query table at once

Formatting multiple columns of a query table at once

Is there a way to do this? I tried selecting the required columns and formatting but it only formats the first column. I have about a hundred columns and hence need help with this.