Change Cell Color based on Dropdown Selection | Excel Tutorial 

Thank you so much! I was only able to change the one cell and couldn't figure out how to do it for the entire column. THANK YOU!!

This video trully help me, thanks men 👍👍👍👍👍👍

This is really good. Can you crate a graph or table with analysis from row E?

It worked!!! Thank you so much! So easy to follow and understand!

works like a charm :)

Thank you i have been trying to do this for a long time .😃

How can one add colour validation to a drop down list that is used across multiple tabs?

Thanks. Very useful

Thank you very helpful ❤

thank you so much for helping , good video

So helpful, thank you!

Good video. I got looking for a solution when I want the same color for may two or more options in the list. Say for example there is "aborted" in the options, and I want the cells color to be red just as "Not started" is there a way to use statement such as OR to combine this rule without having to do another line of conditional formatting for "aborted"?

Great work.

Thanks for this! is there a faster way to colour the drop down list if you have close to 10 options?

I have two sheets in excel, in the first sheet on cell A2 I have a text and the color are green. I want in the sheet 2 on cell A2 to have the same color green. If I change the color on sheet 1 ex yelow automatically change in the sheet 2 the cell A2 in yellow. I have text not numbers in the cell . Conditional formatting not help me because I don't have numbers, I need something like conditional color, I don't know, can you help me ?

ok but how do i create a dropdown list FOR colour values for instance if i have a certain chapter, i want to be able to be able to make it green if im confident with it, instead of writing complete to the right and formatting that instead, to save space

I was able to do data validation and it worked. My question is. Can I make a different cell on the same row change to the same color as the data validation I set up. Example Data validation is on Column H. I have my options with custom colors. ( TC rec'd{orange}, Register sent{yellow}, Approved{green}, Pending{red})- on column B is the list of Companies I run register for. I want Column B to turn the same color as what i Selected in column H. Meaning if i select Register Sent(yellow) Column B on the same row with automatically turn Yellow. I have i exampled it right.

Nice one!

Can you assign a symbol for the option chosen? When I format the cell option to be complete, can I have a green tick inserted in the space, rather than the word complete in a green cell? Thanks for your help.

Excellent - Thank You

Good tutorial BUT this didn't work for me until I created a list of options in the sheet. I just created the list of options a random place far down in the sheet so that it didn't appear up in proximity to my project plan (which is what I use the sheet for - not that that's relevant to this). Once I had that list I could use the list as a data point and THEN follow this video guide and now everything looks good. Thank you.

I have just discovered when i add in a new rows in between existing rows the choice does not include the colour ? how do i get the colour to be added everytime i add a new row?

I have a column with due dates in it. I want the user to be able to select from a list the colour to change the cell to, without changing the contents of the cell (in this case, the date). Can I do that?

hi thanks, for this tutorial. I have a follow up question if you dont mind. in the sample above, is it possible for the product name to automatically change its color as well when status is changed? example if completed is seleted, the status goes green right? how about the text in product name, is it possible to turn green as well?

Thank you

How do you do this for whole row ?

Thankyou

thx!

Could you please do a progress bar

Super helpful, thank you!

Thank you

How do you make the color apply to the whole row