Forum Discussion
Solved
Apply formatting based on previous column value
I need to change background on matrix fields if the "next" phase has a value. I have data as shown, each item has a score for 3 tests. The tests are done 3 times, once for each phase. ...
Please validate your test data. I think a 3 and a 10 are switched (item1, A), and a 9 is missing from the expected output (item2, 3A)
Why would item3, 1A and 1B be red when the 2A and 2B cells are empty?
Thanks Again for pointing me in the right direction between TreatAs and SelectedValue commands I was able to get everything working as desired! Don't know what I would do without this community.