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

[SuyogMorankar]

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?

[seema.kothari1]

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:

AutomationEdge RPA Bot | Excel Bot | Salary Processing and Reports based on an Excel template file

AutomationEdge RPA Bot | Excel Bot | Salary Processing with formatted output based on a template

[seema.kothari1]

Hi! Suyog,

Please try to use Conditional Formatting.