Is there a way to apply eazyBI cell formatting to multiple rows or columns at once?

[Andrew Zimmerman]

Does anyone know of a way to copy the cell formatting of a specific cell row or column and paste it to multiple other cells?

I'm using an eazyBI table to visualize tasks per day per user, and I'm finding that I have to set the cell formatting for each user (column) or each row (date) individually. Is there a way I can apply the same cell formatting rules (mins, maxes, and background colors) to multiple cells columns/rows, or even the entire table?

Thanks for any ideas or workarounds!

[Gerda Zandersone · Accepted solution]

Hi @Andrew Zimmerman
You can apply cell formatting for rows, using the improved cell formatting starting from eazyBI v.6.2: https://docs.eazybi.com/eazybi/analyze-and-visualize/conditional-cell-formatting
It allows you to apply the rule for all rows:

And if you have a measure split by users, then make sure that you apply the formatting to the measure - then the formatting will be applied to all users (all columns).

Kind regards,
Gerda // support@eazyBI.com

[Fabian Lim · Accepted solution]

Hi Andrew,

I don't believe this featue is available yet. You will still have to perform the cell formatting one per column.

Cheers