Copying a format that has been conditionally formated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I cut and paste a formula picking up it's own values if the cell has
been conditionally formatted.
In example, c3 is to highligh in red/bold if it's value is lower than c29
(the value of the same info from year prior). It worked for that cell but I
want to copy the formula for the rest of the 500+ cells so that d3 also read
from d29, etc.

HELP!!
 
What, exactly, is the condition you set? I'm guessing it's something like
'formula is' =($C$3<$C$29). If you use relative cell references, =(C3<C29),
rather than the absolute references, then you should be able to copy / paste
special formats as you've described.
--Bruce
 
You must log in or register to reply here.

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

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional formatting in a formula 1
Copying conditional formating 2
Conditional formating 1
Need help calculating time 8
Excel Conditional Formatting Removal 7
Conditional Formatting 2
Conditional Formatting 4

Back
Top