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.

day	tmp	=repeat("*",A2)
mon	15	************************
tus	10	******************
wed	4	****

<tbody>
</tbody>

 

[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