colore della formattazione condizionale convertirla in color

[comtrex]

Hi You of the forum, I should convert or to fill the cells that have a conditional formatting with some color, the same of the formatting and then to cancel anymore the content the color.

Or do you know how to cancel the content of a cell that and does format without touching the non colored cells?.

Regards

Comtrex

http://www.savefile.com/files/34135 esemple


Io dovrei riempire le celle che sono state colorate con la formattazione con un colore, poi tolgo la formattazione e li cancello mantenendo inalterato le celle senza formattazione.

Oppure cancellare le celel che hanno una formattazione senza alterare le altre.


Saluti
Comtrex



I should fill the cells that have been colored with the formatting with a color, then I remove the formatting and I cancel them maintaining unchanged the cells without formatting.

Or to cancel the cells that have a formatting without altering the others.


Regards
Comtrex

 

[Greg Truby]

Did you download and run the file that I attached to the thread at The Office Experts? I was able to run that from home (XL2002) and the office (XL2003) with no problems.

¿Usted copió el archivo que anexé a la otra hilera en The Office Experts arriba? Puede correr ese de mi casa donde tengo Excel 2002 y lo escribí en mi oficina donde tengo Excel 2003.