It may not display this or other websites correctly. You should upgrade or use an alternative browser. Conditional Format - greyed out? Please can someone help me - I have a spreadsheet which I have "inherited" and trying to add Conditional formatting to a cell, the CF menu selection is greyed out. Any thoughts why? Bob Phillips. It is probably a shared workbook, there is much functionality not available in shared workbooks. Mike H. Hi, 2 Possibilities.
If it is un-protect. If it is un-share. Un-sharing released it. Martin Hanson. Conditional formatting greyed out in Excel is typically as a result of the workbook being a shared workbook. All you need to do is establish the conditional formatting while the workbook is in normal mode and only change to shared mode after you are happy with all the rules.
If you want to edit the conditional formatting you will also need to switch off sharing mode, make the changes, and then switch sharing mode on again. The Excel file format does not support conditional formatting rules that use icon sets.
If you save the file in that file format the conditional formatting for the cell s in question will be discarded in the saved file. What to do Click Find in the Compatibility Checker dialog box to locate each instance of the icon set arrangement. For each instance, choose a conditional format that is supported in Excel , such as formatting the cell with a color.
After you replace all the instances, you can save the file in the Excel file format. Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel. What it means In Excel and later, conditional formatting can contain up to sixty-four conditions, but in Excel , you will see the first three conditions only.
However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel and later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting applied that use more than three conditions, and then make the necessary changes to use no more than three conditions.
Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting.
What it means Overlapping conditional formatting ranges are not supported in Excel , and the conditional formatting is not displayed as expected. What to do In the Compatibility Checker, click Find to locate cells that have overlapping conditional formatting ranges, and then make the necessary changes to avoid overlap.
One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. What it means In Excel , you will not see conditional formatting types, such as data bars, color scales, icon sets, top or bottom ranked values, above or below average values, unique or duplicate values, and table column comparison to determine which cells to format.
What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel and later, and then make the necessary changes to use only formatting types that are supported in the earlier versions of Excel.
Some cells contain conditional formatting with the Stop if True option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition. What it means In Excel , conditional formatting without stopping when the condition has been met is not an option. Conditional formatting is no longer applied after the first condition is true. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting with the Stop if True option cleared, and then click Fix to resolve the compatibility issue.
Thread Tools. Smilies are On. Trackbacks are On. Pingbacks are On. Refbacks are On. The time now is PM. The comments are property of their posters. About Us "It's about Microsoft Excel". Kara external usenet poster. First recorded activity by ExcelBanter: Oct Posts: Dave Peterson external usenet poster. First recorded activity by ExcelBanter: Jul Posts: 35, Conditional Formatting - Greyed Out Is the worksheet protected?
First recorded activity by ExcelBanter: Jul Posts: Conditional Formatting - Greyed Out I'd ask the same questions Conditional Formatting - Greyed Out In xl, you can't change conditional formatting in a shared workbook.
0コメント