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.

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.

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.

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.

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.

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.

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.

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.