color multiple cells in a table the same color when any of the items are selected

**sharky1978** · 10-08-2020, 10:02 AM

hi all

i was wanting to know if there is a way I can color cells when one of the items in my list is selected

i.e my table has drop down boxes in it and i want to change the color when some thing from the list is chosen.

say my list contains monday,tuesday,wednsday,thursday,Friday if any of these are picked it changes to green and in my other list i have jan,feb,mar,apr,may,jun.jul,aug,sep, and if any of these are picked it will turn red

thanks for your help

**KOKOSEK** · 10-08-2020, 10:06 AM

Simple conditional formatting should do the job. If you expect more detailed answer, see yellow banner at the top of forum and upload sample file.

**sharky1978** · 10-08-2020, 10:34 AM

I have added an attachment with an example on it,

I think I'm being thick to be honest but I have tried conditional formatting but it will not let me use the list, all I want it to do is if i select any of the months from
the drop down list I would like the cell to turn green and if any of the week days are selected they turn red i can do it in conditional formatting if I just do 1 day, but
do I do multiple different selection to change

thanks I hope I'm not being to thick

**KOKOSEK** · 10-08-2020, 10:47 AM

Where is dropdown for days of week? In the main part on Table tab all cell contains only months dropdown.
OK. I think I get your point.

Is that what you want?

	B	C	D	E
1	WEEK	RRS CREW	Column1	Column2
2	1	Andy	june	Sunday
3	1	Rob		september
4	1	Anthony		january
5	1	Chris	Thursday

Check attached file.

p.s. yellow backgound is already yours as duplicate.

**sharky1978** · 10-08-2020, 11:05 AM

Sorry the days and the months are on the same drop downs
And Thursday's not ment to be there sorry it was an old tabke i blanked

**KOKOSEK** · 10-08-2020, 11:08 AM

No, they were not. On dropdown were only month's names. Check tab with lists.

**sharky1978** · 10-08-2020, 11:41 AM

sorry I redone the sheet and forgot to post it (sorry made hard work of this thanks for taking the time)

yes that's what I was after

**KOKOSEK** · 10-08-2020, 12:05 PM

Happy to help.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.

**sharky1978** · 10-08-2020, 01:34 PM

thanks

hope i marked this as solved

color multiple cells in a table the same color when any of the items are selected

LinkBack

Thread Tools

Rate This Thread

Display

color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

Re: color multiple cells in a table the same color when any of the items are selected

(Solved )color multiple cells in a table the same color when any of the items are selected

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA to color only certain cells in a selected row

[SOLVED] Find certain color for selected name and replace with other color

merging cells and changing color once option from table is selected

Change all cell's color from selected color

Excel 2007 : Screen COLOR of Selected Cells

[SOLVED] Excel 2003--How do I change the color of selected items?

[SOLVED] How do I change the highlight color of selected menu items?

Bookmarks

Bookmarks

Posting Permissions