Conditional Formatting in Merged Cells

[tycasey17]

I have a three cell merged conditional formatted section with the conditional formatted that has the color starting from one end and fading to white. The information in the cell is derived from a drop down menu. When the information changes only two of the cells changes and the last cell stays the previous color. If I double click on it the hit enter then it’ll change.

Does anyone know how to fix this? I need the three cells because I have information below.

 

[skywriter]

I have a three cell merged conditional formatted section with the conditional formatted that has the color starting from one end and fading to white. The information in the cell is derived from a drop down menu. When the information changes only two of the cells changes and the last cell stays the previous color. If I double click on it the hit enter then it’ll change.

Does anyone know how to fix this? I need the three cells because I have information below.

I think you need to give as much information as possible. Example of data.

How is the conditional formatting being applied, is it through VBA code or is it through the conditional formatting menu?

How does you drop down menu work? Does it reference another cell, is it hard coded etc?

 

[tycasey17]

ConditionalFormatting is through the Menu. I would like to stay away from VBA.
Drop Down Menu, works through the data menu, based off of a list on anothersheet. The list was made into a formula.
Application, There are three cells that are merged together. A drop down menu was placed in the cell toonly select certain criteria. When anyof the criteria is selected it has its own color scheme that I have formattedit to do. The format has a text andbackground effect. The background effectis a two-toned fading color scheme of the color I want fading into white.<o></o>
Issue, Whenthe drop down menu is updated to the current status this will change thebackground. Only two of the merged cellschange properly. The third cell staysthe color of the previous, if you change the drop down again the third cellwill change to the color of the last status. If you double click on the cell and then hit enter it’ll all change tothe right color but if you change the color through the drop down the sameissue occurs<o></o>
TroubleShooting, I have unmerged and remerged the cells. I have cleared all formatting and reformattedthe cells and nothing has changed.

https://docs.google.com/file/d/0Bxt...XA1VjdiMTZTN2VNQ0pWNTNF/edit?usp=docslist_api

 

[skywriter]

Without access to the actual sheet my suggestion would be going into conditional formatting and looking at the rules you have applied and make sure that the place where it shows which cells the formatting applies to reflects the merged cells. If you care to share the sheet with any sensitive data removed I would be more than happy to look at it.

https://www.dropbox.com/