Hi,
I have created a continuous form, and using conditional formatting I have mde the background colours of the cells change due to their value:
<2
2<[value]<4
>4
The code I have seems to work but the whole column of values are the same colour depending on the top entry, other cells are the same colour even if they are different values.
If I click on a cell of a different value, then the whole colum changes again to the criteria of that particular cell.
I cant seem to work it out!
Can anyone help!!?
I have created a continuous form, and using conditional formatting I have mde the background colours of the cells change due to their value:
<2
2<[value]<4
>4
The code I have seems to work but the whole column of values are the same colour depending on the top entry, other cells are the same colour even if they are different values.
If I click on a cell of a different value, then the whole colum changes again to the criteria of that particular cell.
I cant seem to work it out!
Can anyone help!!?
