Conditional Formating Problem

[seenfresh]

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,

 

[xapie128]

Is the cell part of a group of cells that have been merged?
If so, Excel has a problem with conditional formatting merged cells.

 

[seenfresh]

No it's just weird? I check to see if the cell had been merged but it just has 0 in it?

I'm totally confused

 

[seenfresh]

Here is a sample of my work sheet I am trying to c/f if Variance =0 so I can c/f based on the opposite criteria

2006 License Fees.xls
	AH	AI	AJ	AK	AL
9		27,515	27,515	0
10		57,323	57,323	0
11		57,323	57,323	0
12		57,323	57,323	0
13		57,323	57,323	0
14		27,515	27,515	0
15		57,323	57,323	0
16		27,515	27,515	0
PLATFORM