Hi. In 2019 someone asked if it was possible to apply conditional formatting to a table of imported data. I have that same requirement--I've imported a spreadsheet and want to substitute a checkbox for text wherever the cell contains "Yes."
However when I choose to apply formatting to shape and try to select the property (which should be the fields) nothing is there. The condition appears to only apply to the entire table not individual cells in the table. And it is additive i.e. it's not replacing the "yes" instances it's simply putting one small checkbox at some position within the table.
Has anyone come up with a way to do this in the last 3 years? Would greatly appreciate it. Thanks