Microsoft Excel Question

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

I have applied conditional formatting on a cell. If I copy & paste the
format to adjucent cell/s the cell reference does not change. How to solve
this problem?

Thanks in advance for any replies.

Trish
 
Trish said:
I have applied conditional formatting on a cell. If I copy & paste the
format to adjucent cell/s the cell reference does not change. How to solve
this problem?

Thanks in advance for any replies.

Trish
Click to expand...

Copy and paste means just that...the values or formatting of
the original cell are copied to the new cell, including the
cell reference. OTOH, using the fill function to the right,
up, down or left involves relative cell references unless they
are locked by the "$" symbol for either/and row or column. Is
this what you are thinking?
 

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

Microsoft Excel Cell reference make constant 4
Excel VBA 1
How to get the value 30 as per the example? 2
Excel Named Ranges and Conditional Format 3
How can I change `User' to `Trish'? 5
Excel Conditional Formatting Removal 7
raw and column in different color to identify easily 1
in Excel, after cell copy takes few seconds to appear the cursor 2

Back
Top