Forum Discussion
Color coding base on cell below
Hello
I have read this thread and its working but what I'm trying to do is a little bit different
I will like a cell to be green>0 red<0 based on the value of cell below it.
I can manually do it but I will have to do it hundreds of time.
This is what I tried to do.
What is happening at the moment, the row change color base on A3 value. In the small exemple I will like B2 and C2 to be red because B3 and C3 are negative
1 Reply
=A3>0
=A3<0
These rules for conditional formatting work in my file.
=$2:$2
This is the range the format applies to in the example.
