Conditionnal formatting

[jean]

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

 

[isabelle]

hi Jean,

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