Urgent-Conditional formatting lost everytime i close the doc
 

Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Are you saving the document? If the changes are not saved then they will
not be there when you open again.

Misty wrote:

Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Hi Bob,

Thanks for the prompt response and in answer to your question yes i am
saving the changes.

Thanks

"Bob I" wrote:

Are you saving the document? If the changes are not saved then they will
not be there when you open again.

Misty wrote:

Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

then perhaps you have a macro that removes them?

Misty wrote:

Hi Bob,

Thanks for the prompt response and in answer to your question yes i am
saving the changes.

Thanks

"Bob I" wrote:


Are you saving the document? If the changes are not saved then they will
not be there when you open again.

Misty wrote:


Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Misty,

Is the workbook shared?
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Misty" wrote in message
...
Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Hi Earl,

No the workbook isn't shared.

Thanks

"Earl Kiosterud" wrote:

Misty,

Is the workbook shared?
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Misty" wrote in message
...
Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Seems to be a common problem in Office 2007

Bob Morris

"Misty" wrote:

Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.

Urgent-Conditional formatting lost everytime i close the doc
 

Ah-does anyone know how to fix it?

Many thanks

"robert morris" wrote:


Seems to be a common problem in Office 2007

Bob Morris

"Misty" wrote:

Hi,

I am hoping you can help me.

I have one column which has conditional formatting applied (icons) and works
great whe the doc ument is open, however, when i close and re-open the doc,
the coditions are lost and i have to go in an set again. This isn't an issue
for me, however, i have to handover this doc today and i don't think the
person i am handing it over to for use will appreciate it.

Many, many thanks in advance.