software

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$3lt;$C$29). If you use relative cell references, =(C3lt;C29),
rather than the absolute references, then you should be able to copy / paste
special formats as you've described.
--Bruce

quot;taloma715quot; wrote:

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