Copying a format that has been conditionally formated

T

taloma715

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!!
 
B

bpeltzer

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
 
Top