<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Hi 
 
You can use the below… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Color-code-the-cells-in-excel-workbook/m-p/56920#M11021</link>
    <description>Hi&amp;nbsp;
&amp;nbsp;
You can use the below code stage :&amp;nbsp;
Input :&amp;nbsp;Workbook,&amp;nbsp;Handle,&amp;nbsp;Worksheet,&amp;nbsp;ColorCode
&amp;nbsp;
Dim wb, ws As Object
Dim excel, sheet As Object
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
excel.Selection.Interior.Pattern = 1
excel.Selection.Interior.Color = ColorCode
&amp;nbsp;
&amp;nbsp;
You may define the colorcode for the color that you want</description>
    <pubDate>Fri, 10 Aug 2018 11:34:00 GMT</pubDate>
    <dc:creator>NupurSood</dc:creator>
    <dc:date>2018-08-10T11:34:00Z</dc:date>
    <item>
      <title>Color code the cells in excel workbook</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Color-code-the-cells-in-excel-workbook/m-p/56919#M11020</link>
      <description>I extracted the queue reports. Now i want the cells in the excel to be in color based on the cell value (Eg: All the completed cases must be in green, business exceptions in yellow). How can i achieve this color coding?</description>
      <pubDate>Fri, 10 Aug 2018 09:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Color-code-the-cells-in-excel-workbook/m-p/56919#M11020</guid>
      <dc:creator>Niteesh_ReddyBo</dc:creator>
      <dc:date>2018-08-10T09:55:00Z</dc:date>
    </item>
    <item>
      <title>Hi 
 
You can use the below…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Color-code-the-cells-in-excel-workbook/m-p/56920#M11021</link>
      <description>Hi&amp;nbsp;
&amp;nbsp;
You can use the below code stage :&amp;nbsp;
Input :&amp;nbsp;Workbook,&amp;nbsp;Handle,&amp;nbsp;Worksheet,&amp;nbsp;ColorCode
&amp;nbsp;
Dim wb, ws As Object
Dim excel, sheet As Object
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
excel.Selection.Interior.Pattern = 1
excel.Selection.Interior.Color = ColorCode
&amp;nbsp;
&amp;nbsp;
You may define the colorcode for the color that you want</description>
      <pubDate>Fri, 10 Aug 2018 11:34:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Color-code-the-cells-in-excel-workbook/m-p/56920#M11021</guid>
      <dc:creator>NupurSood</dc:creator>
      <dc:date>2018-08-10T11:34:00Z</dc:date>
    </item>
  </channel>
</rss>

