Change Cell Color based on Dropdown Selection | Excel Tutorial

[@honeyrosedianegenon7614]

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

[@LoriBurdette-w8b]

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!!

[@karolzyga868]

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

[@DiegoSarmiento-u3h]

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

[@Steve-rk1co]

what if I want the hole row with color ??

[@libraarc]

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

[@MITutorials]

Not that I know of

[@dianebrianmckerry]

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

[@igortheassistant]

works like a charm :)

[@danal9787]

Awesome. Thanks!

[@tintin6906]

Thank you very helpful ❤

[@AdnanKhan-jo8qn]

Great work.

[@victorified2912]

thank you so much for helping , good video

[@offiongekpenyong1529]

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"?

[@kellykopa4457]

Super helpful, thank you!

[@MITutorials]

You're welcome!

[@Star-vz6mc]

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

[@fadiamin705]

Thanks. Very useful

[@human_in_extinction]

I need something similar but can't find it :'( please help! :') I need the dropdown only to change the fill color, so text can be entered in that same cell and then change the fill color. I want it for a family ruffle I'm setting up, so I can enter the initials of ticket buyers. Maybe I just need a formula that changes fill color if there is any text input in the cell.... I think I just answered my own question, didn't I? XD

[@VeronicaFlores-y7c]

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.

[@MITutorials]

In the conditional formatting “Applies to” section you just need to enter the range which you want to turn yellow in this case the column B

[@ionica.iulian]

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 ?

[@gam8439]

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?

[@MITutorials]

Yes, apply the conditional formatting to the product name cell as well.

[@mareemajor]

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.

[@PuddingMamba]

Nice one!

[@fin5fin]

Excellent - Thank You

[@MITutorials]

You are welcome!

[@deadgameplayer9358]

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

[@angiecentola9920]

How do you make the color apply to the whole row

[@MITutorials]

In the “Applies to” section mention the range of cells where you want to apply the conditional formatting

[@dianebrianmckerry]

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?

[@MITutorials]

Apply the conditional formatting to the entire column.

[@MrStensnask]

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.

[@djannabee4545]

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?

[@MITutorials]

You need to add another column with the Dropdown of the Color and when you select the Color from the Dropdown the Date cell color will change.

[@djameleddine4982]

Could you please do a progress bar

[@MITutorials]

Did this a year ago :)
Add Progress Bar to your Data using Conditional Formatting in Microsoft Excel
th-cam.com/video/zaEFIQLaVHA/w-d-xo.html

[@abdulhamidalhaddadi2255]

Thank you

[@sayedrohani1257]

thx!

[@Iamminnieme]

Thankyou

[@levianhall8729]

So helpful, thank you!

[@JJ-wk8zd]

How do you do this for whole row ?

[@MITutorials]

In the Applies to section enter the whole row range.

[@contradictionsofindia1361]

Thank you