I like to try various fill colors in presentations.  Can I change all of the
same fill colors in aworksheet at the same time?

I'm tring to set up a correlation matrix where a table contains the
same headings in both the x and y axis.  I then use this formula to
find the correlation:
=CORREL($B$2:$B$253,B$2:B$253)

How can I use a formula to pull data from a table with labeled columns and
labeled rows  that when I select  a column label and a row label it would
cross reference both to select  the value. For example : a pricing sheet
shows % of loan amounts financed in columns and rows show ...

I have a spread sheet that read off access but i was wondering if i change
the spread sheet data in excel can access read this to update the data in
access
Also can excel update in realtime or do i have to fresh refresh button all

Win XP
Office '03
Office "07
Hi, is there a keystroke for toggling between worksheets?

How would I create this function to do a Count If the left character in a
range of cells is an "A"?
COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A")
Thank you.

General: Why will links created between two Excel spreadsheets NOT update
properly when the target Excel file is embedded in a PowerPoint chart/file? I
created the original set of files on my desktop and then uploaded to a
SharePoint site?

Hi ya'll I am sorry I keep askin questions, but I have just one more.
Say I have 2 tabs and sheet1 has a list of 150 differnt numbers in
column A. with other information in columns b thru dg. I would like to
know if there is away to go type a number on sheet2 and it

i'm trying to find the wright formula for a facturations problem
i've got a pull down menu in my sheet, i want the next cell to show the
price of the item i choose in the pull down menu
exemple: i choose motor in cell a1 and i want to show the price in cell a2

Is it possible to write an if function on a background color. Say if
a1 has a background color of red return 1 if true and return 0 if
false.

I entered the suggested ABS function (thank you!) and it worked on those
columns that have a consistent - or + on the number but the columns that have
mixed signs show "#value" instead of the sum total of the numbers......any
suggestions?

I have been working on a summary page for reviewing some internal surveys we
do and am hopping soneone might have a simpler solution then what I am
having to do.
The data is in a table that has the month the survey was done and the

Is it possible to write an if function on a background color. Say if
a1 has a background color of red return 1 if true and return 0 if
false.

Hi...I have created my form on excel and have the correct cells locked and
unlocked so the user can use the tab button to get to the next area for
input.  My issue however is my form is in columns A-H and the when using tab
it will take me to cells in I-Z before going to the next ...

How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?
Thank you.