Hey Vital_ar,

Thanks again for your response, but I think I am still not completely clear

with you on what I am looking to accomplish. Yes i do wish to use the ABS

function. You are close, but I want to format the cell in Tab 3, Cell A1,

based on the criteria related to Tab 1, Cell A1, and Tab 2, Cell A1. For

instance, if I use your formula below I will try to show you what I want to

do, but the cell formula does not allow you to reference a different tab than

the tab you are in, and that is why I am asking the question, as I don't know

how else to to what I am trying to accomplish. If I modify your formula to

what I want, i think it would look something like this.

Formula in {Tab 3}[Cell] A1

=AND(ABS({Tab 1} [Cell]A1)<=1,ABS({Tab 2} [Cell]A1)>=1)

Does this help explain a little better what I am looking for? I just don't

know how to accomplish this, as you can not reference Tab 1 or Tab 2 when

writing a formula in Cell A1 of Tab 3, per Excel 2003 help.

Let me know if you have anymore ideas.

Thanks,

Mturboman

Vital_ar said:

Hai Mturboman,

Sorry, I thought tab means cell. Also do u mean ABS reers to the ABS

function.

Ofcourse the formula which i have given is wrong. The correct formula is

given below

=AND(ABS(a1)<=1,ABS(b1)>=1)

(Use it in Conditional formating - Formula is, in the cell c1 and in the

format tab change the color you want). If the a1 value is less than 1 and b1

value is greater than 1 surely the format i.e font or the background color

which you choose in the format tab will surely appear.

Thanks