conditional formatting, cell value > previous cell value (extended over range)

What you need to do is to make columns absolute

so in $B1>$A1

then you van apply the result to any amount of columns by setting the applied range f.e. to B1:K500
that will color all columns from B to K for each row that meets the set formula condition

that works. Only problem now is when the cell in column B is empty and there is something in column A, the cell becomes red ..
I tried someting like and($B1>$A1;$B1>0) but does not work.

that should work. did you forget the = sign before and by any chance?

Formula:

Please Login or Register  to view this content.

Originally Posted by Aardigspook

Use this and apply to the entire range:
In het Nederlands:

Formula:

Please Login or Register  to view this content.

working with 2 laptops with on the one excel in english and on the other one having excel in dutch was my problem.
I used AND when i should have used EN. It works now. Thanks!!

haha, that is a familiar problem for me too

I believe this will solve your problem:

Apply Conditional Formatting on B1, with this formula : =AND(B1>A1,A1<>0)


After that, Use Format Painter on B1 and Select for the entire column. I believe this helps.