and this code works in other tables but for some reason isnt working for this one. Has anyone come across this issue before?
In this example most of my other tables have the column name as [RAG Status] whereas in this one the column name is [Ops_Milestones.RAG Status] and i wonder if the naming convention has something to do with it?
Re: Background colour in straight table only working for some values
No sorry. I thought i clarified in the last paragraph that column name = Ops_Milestones.RAG Status. Sorry i had forgotten that the actual column name was in the screenshot. I was just trying to make the code generic.