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