Conditional Formatting - Greyed Out
I have selected the series that I want to apply Conditional Formatting,
however, it is greyed out. Please advise! |
Answer: Conditional Formatting - Greyed Out
Steps to troubleshoot Conditional Formatting issue in Excel:
If you are still having trouble, please let me know and I'll be happy to assist you further. Additionally, if you can provide more details about your issue, such as the version of Excel you are using or the specific type of Conditional Formatting you are trying to apply, it may help me provide more targeted assistance. Formula:
|
Conditional Formatting - Greyed Out
Is the worksheet protected?
Is the workbook shared? Kara wrote: I have selected the series that I want to apply Conditional Formatting, however, it is greyed out. Please advise! -- Dave Peterson |
Conditional Formatting - Greyed Out
Hello there
Wondering if you can help. I have problem with worksheet at work. Running 2003. I have in some cells formula with if and hlookup. It picks up colour in cell pending answer. IE if comes back due then cell says due and changes to yellow if expired then expired returns andcell changes to red. THese have been set up for some time. I have had to add new columns and rows. In the new ones they are changing to due and expired but not picking up colours. I have looked into conditional formatting but it is greyed out and I cannot select it. The worksheet is not locked but it is shared. Can you advise something please. Also if can help. I can't merge cells on the new ones I have added. I have checked and the worksheet is not locked. -- Thanks for the help Lee "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Kara wrote: I have selected the series that I want to apply Conditional Formatting, however, it is greyed out. Please advise! -- Dave Peterson |
Conditional Formatting - Greyed Out
I'd ask the same questions...
Is the worksheet protected? Is the workbook shared? Lee wrote: Hello there Wondering if you can help. I have problem with worksheet at work. Running 2003. I have in some cells formula with if and hlookup. It picks up colour in cell pending answer. IE if comes back due then cell says due and changes to yellow if expired then expired returns andcell changes to red. THese have been set up for some time. I have had to add new columns and rows. In the new ones they are changing to due and expired but not picking up colours. I have looked into conditional formatting but it is greyed out and I cannot select it. The worksheet is not locked but it is shared. Can you advise something please. Also if can help. I can't merge cells on the new ones I have added. I have checked and the worksheet is not locked. -- Thanks for the help Lee "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Kara wrote: I have selected the series that I want to apply Conditional Formatting, however, it is greyed out. Please advise! -- Dave Peterson -- Dave Peterson |
Conditional Formatting - Greyed Out
Yes I have checked and it is not locked however it is a shared. Would moving
it from 2003 into 2007 help. If I could edit it in 2007 would I lose editing when I put it back into 2003. -- Thanks for the help Lee "Dave Peterson" wrote: I'd ask the same questions... Is the worksheet protected? Is the workbook shared? Lee wrote: Hello there Wondering if you can help. I have problem with worksheet at work. Running 2003. I have in some cells formula with if and hlookup. It picks up colour in cell pending answer. IE if comes back due then cell says due and changes to yellow if expired then expired returns andcell changes to red. THese have been set up for some time. I have had to add new columns and rows. In the new ones they are changing to due and expired but not picking up colours. I have looked into conditional formatting but it is greyed out and I cannot select it. The worksheet is not locked but it is shared. Can you advise something please. Also if can help. I can't merge cells on the new ones I have added. I have checked and the worksheet is not locked. -- Thanks for the help Lee "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Kara wrote: I have selected the series that I want to apply Conditional Formatting, however, it is greyed out. Please advise! -- Dave Peterson -- Dave Peterson |
Conditional Formatting - Greyed Out
In xl2003, you can't change conditional formatting in a shared workbook.
I didn't look at xl2007, but you either test it or look for: "features unavailable in a shared workbook" in xl2007's help. Lee wrote: Yes I have checked and it is not locked however it is a shared. Would moving it from 2003 into 2007 help. If I could edit it in 2007 would I lose editing when I put it back into 2003. -- Thanks for the help Lee "Dave Peterson" wrote: I'd ask the same questions... Is the worksheet protected? Is the workbook shared? Lee wrote: Hello there Wondering if you can help. I have problem with worksheet at work. Running 2003. I have in some cells formula with if and hlookup. It picks up colour in cell pending answer. IE if comes back due then cell says due and changes to yellow if expired then expired returns andcell changes to red. THese have been set up for some time. I have had to add new columns and rows. In the new ones they are changing to due and expired but not picking up colours. I have looked into conditional formatting but it is greyed out and I cannot select it. The worksheet is not locked but it is shared. Can you advise something please. Also if can help. I can't merge cells on the new ones I have added. I have checked and the worksheet is not locked. -- Thanks for the help Lee "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Kara wrote: I have selected the series that I want to apply Conditional Formatting, however, it is greyed out. Please advise! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com