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![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
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
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Thanks