How to update data based on cell's background color

I have a google sheet with some data in it. I have a column with different cell colors. I want to upload data next to that column based on the cell's color.

These are color instructions:

Orange  Negatived added
Blue    To be negatived out
Green   Converted
Yellow  Not sure
Grey    Not to be touched
Red     Cancel Negative.

I'm not a pro on this sort of things. I have been wandering for more than 5 hours but didn't find any helpful resource to do that.