Conditonal Format (2)

[Steve 1962]

I have values in A1 and B1 and values in C1 and D1.

If the count of values in C1 & D1 (can be either 0, 1 or 2 as there are only two colums) does not equal the count of values in A1 & B1 (can be either 0, 1 or 2 as there are only two colums), then I need to conditional format (TRUE) in cell A1 and B1.

Thanks

 

[Habtest]

Does this work?

Book1
	A	B	C	D
1	0	x	9	x
2	0	x	x	x
3	0	1	2	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B3	Expression	=COUNT($A1:$B1)=COUNT($C1:$D1)	text	NO

 

[Steve 1962]

Thanks Habtest.

I used the formula suggested but it didn't seem to work. Maybe I did something wrong.

I am actually using columns K, M and O, P but modified the formula to suit.

I also modified the formula (below) but it is not working also.

=(COUNT(K3)+COUNT(M3))<>(COUNT(O3)+COUNT(P3))

Thanks

 

[Habtest]

Hi Steve, try this instead, mind the absolute reference as in "$K1", and sorry I misunderstood and was doing the opposite of the question.

Book1
	K	L	M	N	O	P
1	0		x		9	x
2	0		x		x	x
3	0		1		2	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K1:K3,M1:M3	Expression	=(ISNUMBER($K1)+ISNUMBER($M1))<>(ISNUMBER($O1)+ISNUMBER($P1))	text	NO

Hope it works, otherwise please check if the value cells are truly values (see if ISNUMBER() returns TRUE), or upload a sample of your data.

 

[Saba Sabaratnam]

Or you could use this function to conditionally format A1

=IF(AGGREGATE(3,4,C1:D1)=AGGREGATE(3,4,A1:B1),TRUE,FALSE)

Check the screen shot of my spreadsheet to see if it is what you want.

Kind regards

Saba