It gave me an error. I'll write it out actual.
I have a tab called "Weekly" which is my main sheet.
My other tabs are "Work Order Labor1" thru "Work Order Labor6"
In Weekly I have cell E7 where I need to enter this formula.
"Weekly" E7 needs to add up tabs "Work Order1" through "Work Order6", cells
G7, J7, M7, P7, S7, V7, Y7, and AB7. Its these same cells in all the work
order tabs.
Weekly E7 needs to take that total, and compare it to "Weekly" tab, cell AC7.
If the numbers match, I want the cell to be blank, if the numbers dont
match, higher or lower, either mark cell E7 red, or put an "X" in it.

I hope this explains it better, sorry for the weak original description.

"bj" wrote:

I am not sure exactly what you want but
your cell a1 equation could be
=Sum('tab2:tab6'!A1:A3)
I do not know if you want A1 or A5 to turn red
I will assume A1
select A1
<format<conditional format Value is not equal to A5
set format pattern to red

if it is A5 you want t6o change to red
Select A5
<format<conditional format Value is not equal to A1
set format pattern to red


"KB" wrote:

I have a spreadsheet with multiple tabs. The first tab tallys numbers from
other tabs, and compares them with data on the first tab. ex: tab1- tab6. In
tab1, I have a cell, lets say A1 where I need to add tab2-a1, a2, a3 + tab3-
a1,a2,a3 (and so on up to tab6). Then once those cells are added up, I need
it to compare the added number to cell a5 on tab1, if the numbers match,
leave that cell blank. If the two number differ, more or less, I need that
cell to turn red. If I cant make it change color, then mark that cell with an
"X". I keep getting a too many commands rule when I try this.

Thanks!