Copy & paste conditional format

W

WCDoan

I have several workbooks with monthly sheets in each. I need to format one
cell to print differently than the previous cell if this cell is greater than
the previous cell. I thought I could do a conditional format and then use
fill handle to format the other cells as you would a formula and the
reference to the cell being checked would change appropriately. I even took
out the $ absolute reference symbol hoping it would make a difference. It
doesn't. I tried copying and paste special, still nothing. It will add the
conditional format, but it still references the cell entered in the initial
conditional format. Is it possible to do what I'm trying to do? I don't
relish the thought of having to go thru several hundred cells applying this
one format. If anyone has an answer, I would be very appreciative.
Thanks,
RandyM
 
S

SteveW

Select Format, not Formula in Paste Special

Forumal only refers to the cell formula
Its a Format you want to copy.

Steve
 

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

Paste to excel from word - auto format problem 1
Conditional formatting disappears when cell contents deleted 2
VB Script reference cells for in current table? 1
Linking data in MS Word into Excel 5
Visio shape text disappears upon copy paste 1
Conditional format if difference in cell values greater than 0.50% 1
conditional format fails when copied 1
conditional formatting, filtering then copying to another sheet 0

Top