I'm trying to conditionally format a row of calculated values displayed at
percents with icons such that >100% - red light, 95 - 100% - yellow light,
<95% - green light.  It seems that the  Conditional Formatting Rules Manager
is inconsistently tagging values - one time it tags ...

I'm having problems creating a formula for adding the values of cells in one
column based on the values in another column. It's currency based so I'm
trying to figure out how to add all the values in one column based on whether
a row in another column contains a certain currency, ...

In Lotus the cells that are unprotected show the font in blue (so you can see
where you've lifted security).  This is only in the screen view (the font
still prints normal/black).
I can't find that Excel has any way to change the view features on

When I insert a Check Box onto a worksheet, then right-click the box and
select Format Control, I don't get the Format tab to appear.  Only 4 tabs
show up - Size, Protection, Properties (object positioning), & Web.  How do I
get the Format tab to appear?

I have created a worksheet with protected and unprotected cells.  I have
created a area C2:J10 as an area for the user to post a picture.  However
when the worksheet is protected the option is grayed out.  Is there a way to
insert a photo into a protected sheet?  I've spent hours ...

how i do translat arabic to english?

i have group of 70 cells with different numbers in them.
i have another group of cells that contain the numbers 1 - 200
if a number from group 1 matches a number from group 2 i want some action to
happen.

I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is € then * by 0.68. That way I could ...

I have an Excel spreadsheet with a header that contains the exact
same
30 names as the corresponding 30 fields in an Access DB table, and
Row

How do I format a cell to not show 0 as being negative?  Could it be the
formula I'm using?  This is the formula in cell L321  
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2 places

Hi, I will try my best to explain. I need to have conditional formatting as
such:
3 cells in adjacent columns. first has name, second has text missed punch,
third has date of error. I need the 3 cells to be removed(possibly to

In excell worksheet there is a cell named: Total Sales which requires data
from Access sales data sales which has the report/form if we run can produce
the total YTD  Sales.
My question is how can we link this excell cell to the access total YTD

On sheet1 I have the following data:
A                 B
111          NAME_1
222          NAME_2

Problem 1:
Rate of Interest (ROI): 7.50% - Compounded Quarterly
Annual Rate Compounded: =FV(7.50%/4,4,0,-1)-1 ie 0.0771
Minimum Investment=Rs. 10 per month

I have a spreadsheet of UNC drive mappings.   I need to extract out
just the name of the server from the fields.
Example:
\\SERVER01\user