Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy and paste conditional formatting for the cell next to
Im creating a rate tracking sheet for a mortgage company. the rates are in
one column and will set off a color of red if they are .5% under the target rate or blue if if the rate is .25%-.5%. Both of these columns are right next to eachother. (Columns H and I) I need to make about 1500 rows and so far ive done about 50 manually without copy and pasting. its very tedious if anybody has any formulas that would be very helpful. Cheers... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy and paste conditional formatting for the cell next to
I'm not certain that I followed your question correctly, but have you tried
Copy (from the formatted cell) and then Paste Special - Formats? You would have to make sure the formulas in the conditional formatting have the proper cell referencing, of course (i.e. relative vs. absolute). Will "Kyle" wrote: Im creating a rate tracking sheet for a mortgage company. the rates are in one column and will set off a color of red if they are .5% under the target rate or blue if if the rate is .25%-.5%. Both of these columns are right next to eachother. (Columns H and I) I need to make about 1500 rows and so far ive done about 50 manually without copy and pasting. its very tedious if anybody has any formulas that would be very helpful. Cheers... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy and paste conditional formatting for the cell next to
Either select all the cells first then go to FormatCF and enter the rules.
Watch out for Excel making Absolute addresses like $I$1 OR use the Format Paintbrush to copy the fomatting. Gord Dibben MS Excel MVP On Wed, 18 Jul 2007 14:06:01 -0700, Kyle wrote: Im creating a rate tracking sheet for a mortgage company. the rates are in one column and will set off a color of red if they are .5% under the target rate or blue if if the rate is .25%-.5%. Both of these columns are right next to eachother. (Columns H and I) I need to make about 1500 rows and so far ive done about 50 manually without copy and pasting. its very tedious if anybody has any formulas that would be very helpful. Cheers... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy and paste conditional formatting for the cell next
I've tried the formula paintbrush but that just copies the formatting to one
cell. Im trying to do somethig like this: I2 formats to H2 I3 fromats to H3 I4 formats to H4 So if I use the formatting brush then it would format all of the cells to one single cell. Im looking for all of the cells to be formated or relate to the cell in the column next to it. "Gord Dibben" wrote: Either select all the cells first then go to FormatCF and enter the rules. Watch out for Excel making Absolute addresses like $I$1 OR use the Format Paintbrush to copy the fomatting. Gord Dibben MS Excel MVP On Wed, 18 Jul 2007 14:06:01 -0700, Kyle wrote: Im creating a rate tracking sheet for a mortgage company. the rates are in one column and will set off a color of red if they are .5% under the target rate or blue if if the rate is .25%-.5%. Both of these columns are right next to eachother. (Columns H and I) I need to make about 1500 rows and so far ive done about 50 manually without copy and pasting. its very tedious if anybody has any formulas that would be very helpful. Cheers... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy and paste conditional formatting for the cell next
Post an example of what you use for the CF in H2 and H3 etc.
Is it a formula or just "cell value is" If a formula, could be the cell referencing is not right for copying. Gord On Thu, 19 Jul 2007 06:26:07 -0700, Kyle wrote: I've tried the formula paintbrush but that just copies the formatting to one cell. Im trying to do somethig like this: I2 formats to H2 I3 fromats to H3 I4 formats to H4 So if I use the formatting brush then it would format all of the cells to one single cell. Im looking for all of the cells to be formated or relate to the cell in the column next to it. "Gord Dibben" wrote: Either select all the cells first then go to FormatCF and enter the rules. Watch out for Excel making Absolute addresses like $I$1 OR use the Format Paintbrush to copy the fomatting. Gord Dibben MS Excel MVP On Wed, 18 Jul 2007 14:06:01 -0700, Kyle wrote: Im creating a rate tracking sheet for a mortgage company. the rates are in one column and will set off a color of red if they are .5% under the target rate or blue if if the rate is .25%-.5%. Both of these columns are right next to eachother. (Columns H and I) I need to make about 1500 rows and so far ive done about 50 manually without copy and pasting. its very tedious if anybody has any formulas that would be very helpful. Cheers... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting - copy & paste to an email | Excel Discussion (Misc queries) | |||
copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
Conditional formatting -- copy paste special won't change referenc | Excel Discussion (Misc queries) | |||
Copy paste Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Paste Conditional Formatting | Excel Discussion (Misc queries) |