# Keep Cell Highlight as it is from Excel Input to new dynamic Excel file

**URL:** <https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634>\
**Category:** Process Studio\
**Tags:** rpa, plugin, process-studio, excel, data-massaging\
**Created:** [September 11, 2023, 10:53am UTC](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634 "2023-09-11T10:53:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SuyogMorankar](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@SuyogMorankar](https://community.automationedge.com/u/SuyogMorankar)\
**Post date:** [September 11, 2023, 10:53am UTC](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634/1 "2023-09-11T10:53:20Z")

</div>

Hey AE community,  
I have an excel file having some **highlighted cells** (Indicating Invalid Data), I want to generate **row-wise new files** from previous file having the same cells highlighted **dynamically**. Can anyone guide me through this process?

---

<div class="post-metadata">

**Author:** ![Jane](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@Jane](https://community.automationedge.com/u/Jane)\
**Post date:** [September 12, 2023, 6:16am UTC](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634/2 "2023-09-12T06:16:32Z")

</div>

Hi! Suyog,

You can use a Template excel file with preformatted cells for this purpose.

You can refer to videos from the AutomationEdge CookBook YouTube channel:

[![](https://img.youtube.com/vi/d5UN-qLfb1M/maxresdefault.jpg "AutomationEdge RPA Bot | Excel Bot | Salary Processing and Reports based on an Excel template file") ](https://www.youtube.com/watch?v=d5UN-qLfb1M)

[![](https://img.youtube.com/vi/D3zH6umOXXY/maxresdefault.jpg "AutomationEdge RPA Bot | Excel Bot | Salary Processing with formatted output based on a template") ](https://www.youtube.com/watch?v=D3zH6umOXXY)

---

<div class="post-metadata">

**Author:** ![Jane](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@Jane](https://community.automationedge.com/u/Jane)\
**Post date:** [September 12, 2023, 9:46am UTC](https://community.automationedge.com/t/keep-cell-highlight-as-it-is-from-excel-input-to-new-dynamic-excel-file/10634/3 "2023-09-12T09:46:21Z")

</div>

Hi! Suyog,

Please try to use Conditional Formatting.