Correct the circular reference and recalculate your spreadsheet.You can fix most recalculation problems with one of these three solutions. I want the form to be displayed with the conditional formatting once I click the button. as the conditional formatting does work but needs a mouse click to give it focus I assume, then the control background changes. top not working and bottom is the desired result where there is a match. it stays the same, however if I click on the control with my mouse it DOES change color based on the conditional formatting. This is definitely not a conditional formatting issue ..
When a cell formatted as General and the cell contains a reference to another cell, Excel copies the format of the referenced cell. and I cannot just query for the data on the radio I entered .. Or it might be easier if you posted the d B for analysis. Adapting This Trick for Conditional Formatting Now, just as we learned last time around, we can use "if" statements in concert with the INDIRECT function to apply conditional formatting by using the "Custom formula" option in the Conditional Formatting dialog.You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. On the Formulas ribbon, look to the far right and click Calculation Options.