Drop down list - Conditional Formatting.

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
66
Office Version
  1. 365
Platform
  1. Windows
Does anyone know why my drop down list doesn’t change all of the merged cells colours (conditional formatting applied with a "Text that Contains" value) when changing between the different list options? It changes x2 of the cells and leaves x1 the previous colour. Seems to only do it when the merged area is made of x3 cells ( I know merged cells are bad) Drop downs are made with Data Validation.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Post some data sample, incl. the CF formula.
 

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
66
Office Version
  1. 365
Platform
  1. Windows
Its a simple drop down, made by entering text in two cells. Then I've used data validation, list, and then highlighted the two cells where the text is as the reference cells. Then I've highlighted the merged cell with the list in and then selected conditional formatting, text that contains and then selected a colour. The conditional formatting formula is =$J$9:$L$9 but it doesnt seem to matter what formula you enter it always leave the last cell out of the three the previous colour (Tower entry is red, Ground entry is white)
 

Attachments

  • Screenshot 2021-09-16 123651.jpg
    Screenshot 2021-09-16 123651.jpg
    40.3 KB · Views: 13
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,579
Messages
5,770,969
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top