Hi, I'm a rookie, and would appreciate help.
my spread sheet looks something like this.
A B
79/6:30am 235/11:30am
The numbers before the forward slash eg: 79 and 235 are blood sugar numbers and after the forward slash are the times they were taken.
I want to develop a formula so that when the blood sugar numbers are below 80 the cell is red and when numbers are over 180 the cell is blue. I'm finding it difficult to find a formula that will change the cell color based on numbers before the slash and ignore the ones after it. Thanks
my spread sheet looks something like this.
A B
79/6:30am 235/11:30am
The numbers before the forward slash eg: 79 and 235 are blood sugar numbers and after the forward slash are the times they were taken.
I want to develop a formula so that when the blood sugar numbers are below 80 the cell is red and when numbers are over 180 the cell is blue. I'm finding it difficult to find a formula that will change the cell color based on numbers before the slash and ignore the ones after it. Thanks