Highlight your range(Let's say A1:A100)
In Conditional format rules.
1) =$a2>$a1 >> Color green>>ok
2) =$a2<$a1 >>Color Yellow>>ok.
Highlight your range(Let's say A1:A100)
In Conditional format rules.
1) =$a2>$a1 >> Color green>>ok
2) =$a2<$a1 >>Color Yellow>>ok.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks