Conditional Formatting help

[Paul Mc1982]

Hi,

I am trying to conditional format a table. I want that days columns to go red when a number entered in the "In" column doesn't equal that of the "out" column. But stay normal if they add up like below.
Any help is appreciated. Thanks

 

[awoohaw]

Welcome to the forum. Try this:
You'll need to update to fit your cell references.

NOTE: I'm not sure if your data is in an actual Excel Table or not, since you have duplicate column headers .

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Sunday		Monday		Tuesday		Wednesday		Thursday		Friday		Saturday
2		In	Out	In	Out	In	Out	In	Out	In	Out	In	Out	In	Out
3	Putaway	1		1		1		1			2
4	Pick		1		1	1			1
5	Transfer		1				2			1
6
7	rule work:	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE
Sheet1

Cell Formulas
Range	Formula
B7	B7	=IF(ISEVEN(COLUMN(B3)),SUM(B$3:B$5)<>SUM(C$3:C$5),SUM(A$3:A$5)<>SUM(B$3:B$5))
C7:O7	C7	=IF(ISEVEN(COLUMN(C3)),SUM(C3:C5)<>SUM(D3:D5),SUM(B3:B5)<>SUM(C3:C5))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:O5	Expression	=IF(ISEVEN(COLUMN(B3)),SUM(B$3:B$5)<>SUM(C$3:C$5),SUM(A$3:A$5)<>SUM(B$3:B$5))	text	NO

 

[Eric W]

Welcome to the forum. Try this:
You'll need to update to fit your cell references.

NOTE: I'm not sure if your data is in an actual Excel Table or not, since you have duplicate column headers .

Clever idea. Here's a slightly shorter formulation:

=SUM(B$3:B$5)<>SUM(IF(ISODD(COLUMN(B3)),A$3:A$5,C$3:C$5))

 

[awoohaw]

Clever idea. Here's a slightly shorter formulation:

=SUM(B$3:B$5)<>SUM(IF(ISODD(COLUMN(B3)),A$3:A$5,C$3:C$5))

Thanks Eric. Excellent update!