Dear All,
In the attached file, I want to format cells (a4 to l14) in a manner
where row colour would be same as appearing in coloumn M. In other
words, in row number 5, I want cells from A to L to be fileld in Green
color, in row 6 in red color, etc.
Is it possible to do so using conditional fo
steps. Don’t forget use F2 and
ctr+shift+enter :)
I hope it can be what you want.
.
On Jul 2, 6:16 am, ASHUTOSH AGARWAL wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
> changed according to row number. e.g. we have a cell with formula "&
Hi All,
Genrally in spreadheet, if you copy a formule in other rows, formula is
changed according to row number. e.g. we have a cell with formula ""=A1" and
now we copy this formula across columns to the right. Naturally, this
results in the Formula reference changing to =B1, =C1, =D1 etc.
Howev
U can also use paste special function...write "1000" in a cell...copy
it...select the data to be dividedthen
paste special...formuladivide.
Hope that it will serve the purpose...
2009/4/23 N.Shivkumar
> I am enclosing the excel file without a macro. Hope the same serves your
> purp
