Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a format that has been conditionally formated
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a format that has been conditionally formated
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 "taloma715" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Date Format Problems?? | Excel Discussion (Misc queries) | |||
insert text conditionally and format | Excel Discussion (Misc queries) | |||
Format into VLookup | Excel Worksheet Functions | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |