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.
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.
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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
