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!! |
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!! |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com