J
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
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