Is your text column fetches Value based on OR , AND conditions.
Please share a sample workbook.
Thanks for your reply. Since the workbook contains confidential details, it is difficult for me share a sample, but I could explain more to see if it helps.
For the text column, it is a group which I grouped some of the values into 3 different statuses.
For the second last column, It is a calculated field which turns the original value into another form.
Hope it helps to explain more about the issues. Thanks.
Tyler it would be better if you post a sample workbook with the data ...
Since the workbook are linked with the company's SQL server with many fields, it is hard to provide a sample.
On the other hand, I figure out the cause of the issue. Since I have used all 16 dimensions and I utilize the text so that I could have an extra column. If I remove the text away from the "Marks", the second last column will become normal with all the cells highlighted in green, but when I put the text back to the "Marks", the issue I mentioned will come up again.
Please kindly advise, thanks.