I'm having issues with relative conditional formatting
i would like to highlight the current price of a list of stocks when it's below my target price.
I've learned that you need to use the INDIRECT formula to point to the relative current and target prices (if you don't do this than you always compare within the first line in the list)
My formula's are correct, returning false and true, but when i incorporate them in conditional formatting, it just doesn't work.
Can someone help out?
The file can be downloaded here
i would like to highlight the current price of a list of stocks when it's below my target price.
I've learned that you need to use the INDIRECT formula to point to the relative current and target prices (if you don't do this than you always compare within the first line in the list)
My formula's are correct, returning false and true, but when i incorporate them in conditional formatting, it just doesn't work.
Can someone help out?
The file can be downloaded here