Hi

As I want to apply conditional formatting based on the value of 2
cells, I use the following formula

=AND(A6<>0,K6=0) So if the 2 conditions are true, cell K6 becomes red
and I am happpy with that

As I want to apply this conditionnal formatting to 250 rows, I just
copy cell K6 to K250

And now comes the problem.

Before the worksheet size was 60 k and after it Jumps to more than 5
Megs ! ! !

what is wrong ?

Thanks for helping

hi Jean,

what is the last cell of this sheet ?
(press Ctrl + End)

--
isabelle


Le 2011-12-14 10:39, jean a écrit :
> Hi
>
> As I want to apply conditional formatting based on the value of 2
> cells, I use the following formula
>
> =AND(A6<>0,K6=0) So if the 2 conditions are true, cell K6 becomes red
> and I am happpy with that
>
> As I want to apply this conditionnal formatting to 250 rows, I just
> copy cell K6 to K250
>
> And now comes the problem.
>
> Before the worksheet size was 60 k and after it Jumps to more than 5
> Megs ! ! !
>
> what is wrong ?
>
> Thanks for helping