I want to c/f cell AK if <>0,
I have entered this formula in the formula is function:
=VARP(AI9,AJ9)<>0
This produces a True argument but the cell will not format to my desired likings?
If I enter in Cell Value is =0 it will not format
There are no decimals evident
Does anyone know what might be the problem with the cell?
Any help would be great!
Thanks in advance,
I have entered this formula in the formula is function:
=VARP(AI9,AJ9)<>0
This produces a True argument but the cell will not format to my desired likings?
If I enter in Cell Value is =0 it will not format
There are no decimals evident
Does anyone know what might be the problem with the cell?
Any help would be great!
Thanks in advance,