Basic Table

[Polite123]

Hi Experts,

Please help me to achieve attached dataset.There is no condition set in terms of number.Only need to colour specific cells as shown below.

Thanks in advance:)

[Emil_Kos]

Hi @Polite123,

I would go with using a template like this (please find attached) and in the output file I would specific Append to existing sheet + Preserve formatting.

Probably there are other ways to achieve it but I think it will fit your purpose:

[atcodedog05]

Hi @Polite123 

I agree with @Emil_Kos if you want specific cells you can use a blank template file with formatting and output your results into it.

You might want to change output options to overwrite sheet from append based on your requirement.

[atcodedog05 · Accepted solution]

Hi @Polite123 

You can use reporting tool also. Advantage is you dont need to have a spare template file all the time you run.

Here is the workflow:

output: outputs to excel too

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[rajatsadan]

Hi @Polite123 ,

Hope this solution works.

[atcodedog05]

Happy to help 🙂 @Polite123 

Cheers and Happy Analyzing 😀