Copying condition formatting cells only

R

Richard Flint

I would like to know if there is a way to copy the
conditional formatting into from one cell to all the other
cells in the column.
However, the referenced cell value will need to change
since it is in the same row.
 
F

Felipe

Richard,

Yes, you can. All you have to do is adjust the cell
reference (from absolute to relative) in the original
conditional formatting, removing or adding the '$' signs
as needed.
If you have trouble with it send a specific example to
help you.

Regards,
Felipe
 

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

Top