repeat() with colors

[lezawang]

Hi
I want to use Repeat() to type "*". My question can I color these "*" to different color depends on the reading? Thank you.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]day[/TD]
[TD]tmp[/TD]
[TD]=repeat("*",A2)[/TD]
[/TR]
[TR]
[TD]mon[/TD]
[TD]15[/TD]
[TD]************************[/TD]
[/TR]
[TR]
[TD]tus[/TD]
[TD]10[/TD]
[TD]******************[/TD]
[/TR]
[TR]
[TD]wed[/TD]
[TD]4[/TD]
[TD]****[/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hi,

Yes ... you can have different colors ... but not using your Repeat() formula ...

You would have to use Conditional Formatting ...

Hope this will help

 

[lezawang]

Thank you. CF with formula or just CF? Thank you.

 

[Fluff]

You will need a formula in Cf for each colour

 

[lezawang]

Thank you. The formula will count how many "*" right?

 

[Fluff]

You can either use the LEN function, or use the value in the tmp col

 

[lezawang]

Thank you, I got it, Thanks again.

 

[Fluff]

You're welcome