logandiana
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 107
I can't figure this out, seems like it should be simple.
If B>A then fill red.
My conditional formatting formula is =$B1>$A1
So for the example below I would expect the middle line to be the only one filled.
In my case though the first line is also filled. I found that to be true because blank is text and text is always greater than any number.
I tried making my iferror return 0 instead of "", which works, but then I have a bunch of 0s in the column and I want blanks where there is no value.
How do I get around this?
<tbody>
</tbody>
If B>A then fill red.
My conditional formatting formula is =$B1>$A1
So for the example below I would expect the middle line to be the only one filled.
In my case though the first line is also filled. I found that to be true because blank is text and text is always greater than any number.
I tried making my iferror return 0 instead of "", which works, but then I have a bunch of 0s in the column and I want blanks where there is no value.
How do I get around this?
| Old Total | New Total |
| 5 | =iferror(vlookup($C2.....),"") returns "" |
| 10 | =iferror(vlookup($C2.....),"") returns 20 |
| 5 | =iferror(vlookup($C2.....),"") returns 3 |
<tbody>
</tbody>
