3
3Pinter
Hi,
I hope this is the correct place to ask my question...
What I want is to create a 'conditional formatting' of two colums.
Example:
1|..a..|..b..|
2|..2..|..5..|
3|..5..|..5..|
4|..5..|..6..|
So colum b is the result of some formulas. Colum a should be 'tested
like this:
IF b > a then a should be red. Unique for each row.
So I used conditional format for each single row:
="$B$2 > $A$2"
But is it possible to create a single formula to check if the value o
colum b is bigger than colum a, checking each row indepedant?
Something like "$B$x > $A$x" where x is the variable.
So my example would be:
2: red
3: nothing
4: nothing
Hope it's clear,
3Pinte
I hope this is the correct place to ask my question...
What I want is to create a 'conditional formatting' of two colums.
Example:
1|..a..|..b..|
2|..2..|..5..|
3|..5..|..5..|
4|..5..|..6..|
So colum b is the result of some formulas. Colum a should be 'tested
like this:
IF b > a then a should be red. Unique for each row.
So I used conditional format for each single row:
="$B$2 > $A$2"
But is it possible to create a single formula to check if the value o
colum b is bigger than colum a, checking each row indepedant?
Something like "$B$x > $A$x" where x is the variable.
So my example would be:
2: red
3: nothing
4: nothing
Hope it's clear,
3Pinte