How do I set conditional formatting for the cells in Column B so they turn a color when the value goes below the first Column (Column A)?
I tried all sorts of stuff, the only thing I could make work on ONE cell is to
1. select the individual cell,
2. click conditional formatting,
3. choose "classic" style
4. format only cells that contain
5. cell value
6. less than
7. and i chose the cell in column A.
8. Format, RED
I COULDN"T Apply this to the the whole column, what i tried to do is select the entire column B, set those conditional formats to that above and then select the entire column A - got an error saying that I might want to use a formula, blah blah blah and it wouldn't work.
I'm sure theres a simple way of doing this, I just can't figure it out! and there's no way I'm doing this on each cell individually.
Anyone know a formula I can just paste into the cell and copy it down the column? Or the steps in conditional formatting?
PS I have Mac Excel 2011
I tried all sorts of stuff, the only thing I could make work on ONE cell is to
1. select the individual cell,
2. click conditional formatting,
3. choose "classic" style
4. format only cells that contain
5. cell value
6. less than
7. and i chose the cell in column A.
8. Format, RED
I COULDN"T Apply this to the the whole column, what i tried to do is select the entire column B, set those conditional formats to that above and then select the entire column A - got an error saying that I might want to use a formula, blah blah blah and it wouldn't work.
I'm sure theres a simple way of doing this, I just can't figure it out! and there's no way I'm doing this on each cell individually.
Anyone know a formula I can just paste into the cell and copy it down the column? Or the steps in conditional formatting?
PS I have Mac Excel 2011