Change shape colors based on cell value

[michelleponan]

Hi Everyone,

I need your help here. I have lists of panels with several shape forms in "Sheet 1" and its panel numbers and status in "Sheet 2".
May I know how to put color on shapes on "Sheet 1" based on values given on column B "Sheet 2". That is
if Column B= "Approved", then color green
if Column B= "Submitted", then color red
if Column B= "Commented", then pink

I attached my spreadsheet so you can have a better understanding.
Thanks.

 

[Momentman]

Hi Everyone,

I need your help here. I have lists of panels with several shape forms in "Sheet 1" and its panel numbers and status in "Sheet 2".
May I know how to put color on shapes on "Sheet 1" based on values given on column B "Sheet 2". That is
if Column B= "Approved", then color green
if Column B= "Submitted", then color red
if Column B= "Commented", then pink

I attached my spreadsheet so you can have a better understanding.
Thanks.

You can't attach a spreadsheet here, what you can do is to upload it to a file sharing site and then post a link here.