FORMULA COPY SHEET IN THE OTHER CELL
 

I made a formula in conditional formatting to create colours A=Yellow,
B=Yellow, P-Blue and C-Gray, I made the following formula which is devided
into three column in which:-

=if($C$236="c",column($C$236),if($T$236="c",column ($O$236),if($C$236="c",column($O$236),

This goes perfectly but the problem is when I drag it to the next row the
formula has been copied in duplicate way in which the Cell value is still the
same.

I change the formula into the ff:-

=if(C236="c",column(C236),if(T236="c",column(O236) ,if(C$36="c",column($O$236),

it goes okey, but the problem is when i open again the formula : the cell
value copied different cell like instead of C236 it became D236 or others...

Can some body tell me my mistake

FORMULA COPY SHEET IN THE OTHER CELL
 

Well in your second post c236 has become c$36, but that is probably just
a typo
If it is copying the formula sideways
=if($C236="c",column($C236),if($T$236="c",column
($O236),if($C236="c",column($O236),

Although you have not posted your full expression above so it is
diffiicult to see also the logic is trange as if the first condition
c36="c" is satisfied (highlighted in green) the other conditions will
not be so the last bit of the expression can never occur (highlighted
in red.)

Maybe you state in english clearly what you want to do and include an
example

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=565033

FORMULA COPY SHEET IN THE OTHER CELL
 

Carol

I think what you need is "mixed references"

The $ sign is used to change cell references from "relative" to absolute". This
fixes the reference so's it will not change as copied down or across.

$A1 is absolute column and relative row.

$A$1 is absolute column and row.

A$1 is relative row and absolute column.

Se help on relative and absolute cell references for more on this.

And a posting from Kassie with examples................

http://snipurl.com/twna


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 23:46:01 -0700, Carol
wrote:

I made a formula in conditional formatting to create colours A=Yellow,
B=Yellow, P-Blue and C-Gray, I made the following formula which is devided
into three column in which:-

=if($C$236="c",column($C$236),if($T$236="c",colum n($O$236),if($C$236="c",column($O$236),

This goes perfectly but the problem is when I drag it to the next row the
formula has been copied in duplicate way in which the Cell value is still the
same.

I change the formula into the ff:-

=if(C236="c",column(C236),if(T236="c",column(O236 ),if(C$36="c",column($O$236),

it goes okey, but the problem is when i open again the formula : the cell
value copied different cell like instead of C236 it became D236 or others...

Can some body tell me my mistake

Gord Dibben MS Excel MVP