You can drag both [Measure Names] and [your Color Logic] on the color shelf ( ctrl-click both and right-drag).
Next Edit the colors and set the R-Y-G for the Sales rc items , and white for all others.
Thanks for your response.
I am unable to drag both the measure names and the color logic calculated field on the color shelf.
I have 6 business functions as it shows in the image file, where I need to color the cell background based on the text value. I have tried looking at the related topics in forums but couldn't find the answer.
Can you post a packaged workbook.
If your data is sensitive, you can mockup something similar using the Superstore datasource provided with Tableau.