Conditional Formatting for Fill Color on Merged Cells

[stfchr]

Hello, I have 3 cells merged into one and inserted a dropdown menu. I have applied conditional formatting to change the fill color when an item is selected from the dropdown. However, when the color changes, it leaves a portion of the merged cell unchanged. Any ideas?

 

[jtakw]

Hi,

Merged cells are never a good idea.
What are the cell addresses of the merged cells, and what's your CF formula?

Chances are, you just need to include all 3 cells in the applies to range, and anchor down the condition cell.

 

[stfchr]

Thanks for your reply. The cell range is listed in "Applies to" (=$D$11:$F$11). The rule is: "Format only cells that contain". There is a separate rule for each possible answer from the dropdown menu.

 

[jtakw]

What is the requirement ?
"Format only cells that contain..." >>>need to know the requirement (e.g. contains What), and in what cell ?

Pretty sure you'll need a CF formula to achieve this, as I would think only 1 cell will contain your requirement.

 

[stfchr]

What is the requirement ?
"Format only cells that contain..." >>>need to know the requirement (e.g. contains What), and in what cell ?

Pretty sure you'll need a CF formula to achieve this, as I would think only 1 cell will contain your requirement.

It is Format only cells that contain "YES", "NO", or "I'M NOT SURE". They are all in the same merged cell (D11:F11) in the dropdown box.

 

[jtakw]

Is it either Yes, No or I'm not sure, in one of the cells D11:F11 ?
If so, which one of these cells.
Or, are you saying All 3 cells will be populated with Yes, No, or I'm not sure ?

May be you can show a sample.

 

[jtakw]

Without sample and further explanation, try this:

Book3.xlsx
	D	E	F
11	Yes
12
13	No
14	I'm not sure
Sheet1053

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D11:F14	Expression	=OR($D11="Yes",$D11="No",$D11="I'm not sure")	text	NO

 

[stfchr]

Yes, all three cells will be populated with one of the selected options. I am not sure how to upload an sample of this. I can try to explain in more detail. When the worksheet is opened, the dropdown box is yellow and reads "Please Select One". Once you click on one of the options from the dropdown, it is supposed to turn white. Does turn white mostly, except for one section of the merged cell containing the dropbox remains yellow. I hope that helps clarify some.

 

[jtakw]

Have you tried what I suggested in Post #7 ???

On a copy of your sheet.
Remove all CF from D11:F11
Select your merged D11:F11
CF, use formula
Enter my formula:
=OR($D11="Yes",$D11="No",$D11="I'm not sure")
Click Format
Select your Formatting as you like.
Click OK.

 

[stfchr]

Have you tried what I suggested in Post #7 ???

On a copy of your sheet.
Remove all CF from D11:F11
Select your merged D11:F11
CF, use formula
Enter my formula:
=OR($D11="Yes",$D11="No",$D11="I'm not sure")
Click Format
Select your Formatting as you like.
Click OK.

Great! Thank you!