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 Order Labor1" through "Work Order
Labor6", 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.

"Don Guillett" wrote:

=(sum(tab2name:tab6name!a1)+sum(etc

=if(a5=sum(tab2name:tab6name!a1)+sum(etc,"","C")
then use formatconditional format to color if cell<"x")
--
Don Guillett
SalesAid Software

"KB" wrote in message
...
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!