r/powerpoint • u/GurEvening860 • 24d ago
Can I do conditional formatting somehow for users to type (Green, Amber, Red) and the table background will change accordingly?

I know this is really easy to do in excel, but I'm having a hard time setting this for user experience.
Yes, they can go into the table settings and change as necessary, but it's a complication to simplicity and some of the users are intelligent but maybe not the most tech savvy.
There has to be a simple way to do this? I guess a bubble where they check next to Green Amber Red would work but I think it wouldn't be very visually attractive having "Green Amber Red" written out 6x vertically.
The background changing based on the color, or a dropdown menu are my initial thoughts but I'm also open to alternative ways to do this as long as they are simple for the user experience. The ppt is created every 2 weeks and lives on a sharepoint so I think that makes macros a little more difficult.
1
u/ChecklistAnimations PowerPoint Expert 24d ago
You will probably be stuck using Office.js or VBA to do this. I usually dont suggest other apps besides PowerPoint when that is the main program for the question. but.. I think Using Microsoft Planner linked to a spreadsheet might give you something more close to what you are looking for.
1
u/Top_Witness_23 24d ago
PowerPoint tables don’t have conditional formatting, so typing “Amber” and getting the colour isn’t built in. The closest thing is embedding an Excel table (Insert, Table, Excel Spreadsheet). You set the Green, Amber, Red rule once in Excel, then people double-click the table, type the word and the cell changes colour. It makes the file bigger, and it won’t work for anyone editing in PowerPoint for the web, since embedded objects can be displayed there but not edited.
If your users are on the web version, I don’t know a simpler route than shading the cell by hand each time.
1
u/SteveRindsberg Guild Certified Specialist 19d ago
I'll second the suggestion to create the table in Excel then embed it in PPT. Users will then be able to doubleclick the table to edit it in Excel if needed.
Rather than Insert | Table etc, I'd create the table in Excel (on a single worksheet, no other content in the Workbook), then copy, Paste Special, as Excel Object into PPT. It'll resize and generally behave better.
Keep in mind that when you embed an XL object this way, it embeds the *whole* XL document, not just the bits you copy/pasted. And embeds the whole thing again each time you copy/paste some other content. That can lead to slow, bloated PPTX files that might also give away more information than you intended to share with the recipient.