=(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!