conditional formating

M

Miri

how do i copy conditional formating from one cell to other?
another question: how do i copy cell (or cells) without conditional
formating but with all others(formula, formats, values)
 
M

Marcelo

Hy,

to copy the conditional formats:

Copy | Paste Special | Formats

To do not copy the conditional format,:
Copy ? Paste Special | Formulas

But you need to format again, conditional format is consider a format on copy

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Miri" escreveu:
 

Ask a Question

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.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Conditional formatting disappears when cell contents deleted 2
Conditional Format Entire Workbook 1
Paste to excel from word - auto format problem 1
Excel 2007 - A Conditional Formatting ?'s 1
Resource name inside resource sheet: per person, work per hours per week 0
Conditional formatting with dates 7
conditional formating 1

Top