PowerPoint Cell Color Shading

Help Studio
1

image
image819×468 14.8 KB

The CPU, Memory, Disk Utilization cell need to be shaded Yellow when the number is between 70-79.99 and Red when the number Red when the numbers are between 80-100. How do I do that? I am not seeing any activity of cell color shading in the Pptx activities. Is there a condition I can do in the Pptx template whereby when the numbers are pasted onto the Pptx, it will automatically turn yellow or red depending on the range of the number?

2

Hi @Baba_Karim_Abdulai

1: Can UiPath PowerPoint Activities Apply Conditional Formatting?

  • UiPath.Presentations.Activities does not support cell-level formatting such as background color changes based on value.
  • There is no activity like Set Cell Color or Conditional Format Cell in this pack, similar to Excel activities.

2: Can You Use a Template with Predefined Conditional Formatting?

  • PowerPoint does not support Excel-style conditional formatting.
  • You cannot embed formulas or dynamic color rules in PowerPoint.

3: Can You Achieve This with UiPath Logic Before Pasting?
I suggest that you first perform all the requirements in Excel itself, then transfer the table from Excel to your PPT.

Step 1: Perform all your table requirements (setting color, etc.) in Excel.
Step 2: Use a method to transfer the table from Excel to PPT (you can take a screenshot of the table by opening Excel).

Let me know if you have any queries.

Cheers!

3

After reviewing the Power Point activities, I think you can update the text but I’m not sure about cell color:

Would you be able to create this dashboard in Excel and then use conditional formatting to adjust the cell color, and then update the dashboard in the PPT?

Here’s the general process:

  1. Select the cells: Choose the range of cells where you want the formatting to be applied.
  2. Go to Conditional Formatting: On the “Home” tab, find the “Conditional Formatting” button in the “Styles” group.
  3. Create a new rule: Click “New Rule…”.
  4. Choose a rule type: Select the appropriate rule type based on your logic. For example, “Format only cells that contain” or “Use a formula to determine which cells to format”.
  5. Define the conditions: Specify the criteria for the formatting. For instance, if you want to highlight cells greater than 10, you would set the condition to “greater than 10”.
  6. Set the formatting: Click the “Format” button to choose the desired fill color, font color, or other formatting options.
  7. Apply the rule: Click “OK” to apply the rule. Excel will now automatically change the cell colors based on your defined logic.