Hi,
I recently wanted to display some information in a table using conditional formatting for ease of reading.
I eventually ended up using the function rept().
It looked just like that:
The rept() function returns a repeated text value a specified number of times.
It is really useful in this case.
Download the following spreadsheet and follow the how-to!
Spreadsheet: KPI using REPT function
Any comment?
