Thanks Biff. I understand what you are saying, and that is a great idea, but
conditional formatting won't allow you to use references to other worksheets
or workbooks. When I tried, Excel gave me an error message.

"Biff" wrote:

Hi!

Use Formula Is and just use the same formula but add the /2 to every one.

Whatever Index formula you have in A1:

=A1=INDEX(.....................))/2

I don't know how to word this but maybe you'll get what I'm trying to
describe. If not I'll try again!

Biff

"Sarah Jane" wrote in message
...
I have several cells with formulas in them, and other cells have the same
formula divided by 2. My real formulas are rather complex, i.e. Cell X6
is
=INDEX(act!$A:$IR,MATCH($D6,act!$D:$D,0),MATCH(X$1 ,act!$1:$1,0))/2.
So, here is a very simplified example:
A B C
row 1: =Sheet1!A1 =Sheet1!B1 =Sheet1!C1
row 2: =Sheet1!A2/2 =Sheet1!B2/2 =Sheet1!C2/2
row 3: =Sheet1!A3 =Sheet1!B3 =Sheet1!C3
row 4: =Sheet1!A4 =Sheet1!B4 =Sheet1!C4
row 5: =Sheet1!A5/2 =Sheet1!B5/2 =Sheet1!C5/2

I want to use the conditional formatting option to highlight the cells
that
are divided by 2. I tried "Formula Is
=IF(RIGHT(A2,2)="/2",TRUE,FALSE)=TRUE"; but since Excel 2003 SP2 is using
the
value of A2 in the calculation instead of looking at the formula, I never
get
a true condition. Then I thought about trying to replace the A2 in the
conditional formula mentioned above with CONCATENATE("'",A2) to fool Excel
into thinking the cell was formatted as text, but that didn't work either
because it still returned the value--only with an ' in front of it.

I have thousands of cells using these formulas, so creating helper columns
with text versions of the formulas is not possible, or at least not
practical. I think I could accomplish this with a macro, but I don't want
to
have to run a macro every time I edit a cell or add more rows or columns.
Therefore, if you know of an Excel formula that I can use to access a
formula's text or you have any other suggestions, PLEASE, PLEASE let me
know.

Thanks,
Sarah Jane Bowers