Hi All
Is simple conditional formatting possible in BO? Can I do it through VBA?
In essence, I have:
Question Ans 1 Ans 2 Ans 3 Ans 4 Ans 5 Average
xxx xxxx? 3 4 4 3 1 3
I want any answers which deviate by more than 1 from the average to show up in bold. So in the above example, Ans 5 would be bold and the others would not.
Many thanks for any help/advice offered
Tom
Is simple conditional formatting possible in BO? Can I do it through VBA?
In essence, I have:
Question Ans 1 Ans 2 Ans 3 Ans 4 Ans 5 Average
xxx xxxx? 3 4 4 3 1 3
I want any answers which deviate by more than 1 from the average to show up in bold. So in the above example, Ans 5 would be bold and the others would not.
Many thanks for any help/advice offered
Tom