Hi,
I am having issues with some conditional formatting.
I am wanting cells to look at a value of the cell next to it, and if it is higher than that cell turn green, if its less than that amount then turn red. Simple!Apparently not!
Column A contains the value I type in that I want to change colour
Column B contains a value that is already populated and will be either over 0 or less than 0
How can I do this without setting up each condition separately for each cell
Thanks
I am having issues with some conditional formatting.
I am wanting cells to look at a value of the cell next to it, and if it is higher than that cell turn green, if its less than that amount then turn red. Simple!Apparently not!
Column A contains the value I type in that I want to change colour
Column B contains a value that is already populated and will be either over 0 or less than 0
How can I do this without setting up each condition separately for each cell

Thanks