conditional formatting referencing 3 cells by row in a range

Hi, 
I need to set up conditional formatting with 3 conditions and each condition 
is to look at 3 different cells in a row and determine if they meet the 
condition.  Currently what I have setup does not limit the conditions to have 
all 3 in the same row...it will indicate that I have met the condition when 
in fact one of the values is only true if you look in different rows (see 
example).
Here is what I have setup so far:
condition 1 - 
AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
condition 2 - 
AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
condtion 3 - 
=AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))

and example of the data is as follows:
	column a	column b	column c	column d	column e	column f
row 18	"Unit "	"Desc"	"Type"	"Status"	"WO"	"WO Desc"
row 19	1004M1	SWIVEL 	S	15	605161	REPLACE SEAL FOR COUPLING
row 20	1004M1	SWIVEL 	S	15	605161	REPLACE SEAL FOR COUPLING
row 21	1005M3	SL1 ROLL 	P	40	607696	Drive Service - Shutdown
row 22	1006	HEAD 1 	S	15	582290	replace skirting
row 23	1006	HEAD 1 	P	40	600453	FRMING HEAD INSPCTION
row 24	1006	HEAD 1 	P	40	608227	FRMING HEAD INSPCTION
row 25	1006M12	ROLL 2 	S	10	607840	Change rosta.
row 26	1007	CONV	S	40	398889	INSTALL GREASE LINES ON SCREWS
row 27	1007	CONV	P	40	605779	Swivel Trough Mechanical Insp
row 28	1008	BIN 4 	S	40	441259	CHANGE DECK
row 29	1008M3	PICKER 	P	40	594158	Drive Service - Shutdown
row 30	1008M3	PICKER 	P	40	603352	Pick Rolls Insp - Operating
row 31	1008M3	PICKER 	P	40	605910	PICK ROLL DRIVE OPER-INSP

I set up the conditional formatting on column E.  Cell E29 is meeting 
condition 2 when it shouldn't because the 3 criteria cannot all be found in 
Row 29...

Please help  :)
0
Utf
12/7/2009 6:25:01 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
629 Views

Similar Articles

[PageSpeed] 33

The formula for condition 3:

>=AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))

The COUNTIF criteria refers to E29, A29 and F29. The formulas for conditions 
1 and 2 refer to E19, A19 and F19.

Is the formula for condition 3 correct?

Condition 2 for row 29 does meet the criteria.

AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))

Based on the sample data:

COUNTIF($E$19:$E$10000,$E19)=1 = TRUE (1 instance of 594158)

COUNTIF($A$19:$A$10000,$A19)>1 = TRUE (3 instances of 1008M3)

COUNTIF($F$19:$F$10000,$F29)>1 = TRUE (2 instances of Drive Service - 
Shutdown)

-- 
Biff
Microsoft Excel MVP


"TheMTCGal" <TheMTCGal@discussions.microsoft.com> wrote in message 
news:3988A0B7-DD4D-45C2-8B80-2B82BBC09934@microsoft.com...
> Hi,
> I need to set up conditional formatting with 3 conditions and each 
> condition
> is to look at 3 different cells in a row and determine if they meet the
> condition.  Currently what I have setup does not limit the conditions to 
> have
> all 3 in the same row...it will indicate that I have met the condition 
> when
> in fact one of the values is only true if you look in different rows (see
> example).
> Here is what I have setup so far:
> condition 1 -
> AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
> condition 2 -
> AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
> condtion 3 -
> =AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))
>
> and example of the data is as follows:
> column a column b column c column d column e column f
> row 18 "Unit " "Desc" "Type" "Status" "WO" "WO Desc"
> row 19 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING
> row 20 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING
> row 21 1005M3 SL1 ROLL P 40 607696 Drive Service - Shutdown
> row 22 1006 HEAD 1 S 15 582290 replace skirting
> row 23 1006 HEAD 1 P 40 600453 FRMING HEAD INSPCTION
> row 24 1006 HEAD 1 P 40 608227 FRMING HEAD INSPCTION
> row 25 1006M12 ROLL 2 S 10 607840 Change rosta.
> row 26 1007 CONV S 40 398889 INSTALL GREASE LINES ON SCREWS
> row 27 1007 CONV P 40 605779 Swivel Trough Mechanical Insp
> row 28 1008 BIN 4 S 40 441259 CHANGE DECK
> row 29 1008M3 PICKER P 40 594158 Drive Service - Shutdown
> row 30 1008M3 PICKER P 40 603352 Pick Rolls Insp - Operating
> row 31 1008M3 PICKER P 40 605910 PICK ROLL DRIVE OPER-INSP
>
> I set up the conditional formatting on column E.  Cell E29 is meeting
> condition 2 when it shouldn't because the 3 criteria cannot all be found 
> in
> Row 29...
>
> Please help  :) 


0
T
12/7/2009 10:03:05 PM
Argh! Copy/paste typos...

>Based on the sample data:

COUNTIF($E$19:$E$10000,$E29)=1 = TRUE (1 instance of 594158)

COUNTIF($A$19:$A$10000,$A29)>1 = TRUE (3 instances of 1008M3)

COUNTIF($F$19:$F$10000,$F29)>1 = TRUE (2 instances of Drive Service - 
Shutdown)

-- 
Biff
Microsoft Excel MVP


"T. Valko" <biffinpitt@comcast.net> wrote in message 
news:uQU$Nk4dKHA.1652@TK2MSFTNGP05.phx.gbl...
> The formula for condition 3:
>
>>=AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))
>
> The COUNTIF criteria refers to E29, A29 and F29. The formulas for 
> conditions 1 and 2 refer to E19, A19 and F19.
>
> Is the formula for condition 3 correct?
>
> Condition 2 for row 29 does meet the criteria.
>
> AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
>
> Based on the sample data:
>
> COUNTIF($E$19:$E$10000,$E19)=1 = TRUE (1 instance of 594158)
>
> COUNTIF($A$19:$A$10000,$A19)>1 = TRUE (3 instances of 1008M3)
>
> COUNTIF($F$19:$F$10000,$F29)>1 = TRUE (2 instances of Drive Service - 
> Shutdown)
>
> -- 
> Biff
> Microsoft Excel MVP
>
>
> "TheMTCGal" <TheMTCGal@discussions.microsoft.com> wrote in message 
> news:3988A0B7-DD4D-45C2-8B80-2B82BBC09934@microsoft.com...
>> Hi,
>> I need to set up conditional formatting with 3 conditions and each 
>> condition
>> is to look at 3 different cells in a row and determine if they meet the
>> condition.  Currently what I have setup does not limit the conditions to 
>> have
>> all 3 in the same row...it will indicate that I have met the condition 
>> when
>> in fact one of the values is only true if you look in different rows (see
>> example).
>> Here is what I have setup so far:
>> condition 1 -
>> AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
>> condition 2 -
>> AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
>> condtion 3 -
>> =AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))
>>
>> and example of the data is as follows:
>> column a column b column c column d column e column f
>> row 18 "Unit " "Desc" "Type" "Status" "WO" "WO Desc"
>> row 19 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING
>> row 20 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING
>> row 21 1005M3 SL1 ROLL P 40 607696 Drive Service - Shutdown
>> row 22 1006 HEAD 1 S 15 582290 replace skirting
>> row 23 1006 HEAD 1 P 40 600453 FRMING HEAD INSPCTION
>> row 24 1006 HEAD 1 P 40 608227 FRMING HEAD INSPCTION
>> row 25 1006M12 ROLL 2 S 10 607840 Change rosta.
>> row 26 1007 CONV S 40 398889 INSTALL GREASE LINES ON SCREWS
>> row 27 1007 CONV P 40 605779 Swivel Trough Mechanical Insp
>> row 28 1008 BIN 4 S 40 441259 CHANGE DECK
>> row 29 1008M3 PICKER P 40 594158 Drive Service - Shutdown
>> row 30 1008M3 PICKER P 40 603352 Pick Rolls Insp - Operating
>> row 31 1008M3 PICKER P 40 605910 PICK ROLL DRIVE OPER-INSP
>>
>> I set up the conditional formatting on column E.  Cell E29 is meeting
>> condition 2 when it shouldn't because the 3 criteria cannot all be found 
>> in
>> Row 29...
>>
>> Please help  :)
>
> 


0
T
12/7/2009 10:17:43 PM
Your 1st and 2nd condition is perfect.  But the 3rd condition is incorrect 
which is described below:-

condition 1 -
=AND((COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
condition 2 - 
=AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))

But in your 3rd condition look the countif criteria you have mentioned the 
Cell reference as $E29, $A29 & $F29 instead of $E19, $A19 & $F19.  That is 
the reason you are not getting the correct conditional formatting.

Your Wrong 3rd Conditional formatting Formula
condtion 3 - 
=AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))

Actual formula should be like the below for Condition 3
=AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)=1),(COUNTIF($F$19:$F$10000,$F19)=1))

While applying the above three conditions Place the Cursor in A19 cell and 
upto F19 by holding shift and pressing the right arrow and now extend your 
selection upto row 10000 (i.e.) A19: F10000.  Now go to Format>>Conditional 
formatting and paste the first 2 conditions and the Corrected formula in 3rd 
condition and apply the formatting accordingly.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"TheMTCGal" wrote:

> Hi, 
> I need to set up conditional formatting with 3 conditions and each condition 
> is to look at 3 different cells in a row and determine if they meet the 
> condition.  Currently what I have setup does not limit the conditions to have 
> all 3 in the same row...it will indicate that I have met the condition when 
> in fact one of the values is only true if you look in different rows (see 
> example).
> Here is what I have setup so far:
> condition 1 - 
> AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
> condition 2 - 
> AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))
> condtion 3 - 
> =AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))
> 
> and example of the data is as follows:
> 	column a	column b	column c	column d	column e	column f
> row 18	"Unit "	"Desc"	"Type"	"Status"	"WO"	"WO Desc"
> row 19	1004M1	SWIVEL 	S	15	605161	REPLACE SEAL FOR COUPLING
> row 20	1004M1	SWIVEL 	S	15	605161	REPLACE SEAL FOR COUPLING
> row 21	1005M3	SL1 ROLL 	P	40	607696	Drive Service - Shutdown
> row 22	1006	HEAD 1 	S	15	582290	replace skirting
> row 23	1006	HEAD 1 	P	40	600453	FRMING HEAD INSPCTION
> row 24	1006	HEAD 1 	P	40	608227	FRMING HEAD INSPCTION
> row 25	1006M12	ROLL 2 	S	10	607840	Change rosta.
> row 26	1007	CONV	S	40	398889	INSTALL GREASE LINES ON SCREWS
> row 27	1007	CONV	P	40	605779	Swivel Trough Mechanical Insp
> row 28	1008	BIN 4 	S	40	441259	CHANGE DECK
> row 29	1008M3	PICKER 	P	40	594158	Drive Service - Shutdown
> row 30	1008M3	PICKER 	P	40	603352	Pick Rolls Insp - Operating
> row 31	1008M3	PICKER 	P	40	605910	PICK ROLL DRIVE OPER-INSP
> 
> I set up the conditional formatting on column E.  Cell E29 is meeting 
> condition 2 when it shouldn't because the 3 criteria cannot all be found in 
> Row 29...
> 
> Please help  :)
0
Utf
12/8/2009 8:12:01 AM
Reply:

Similar Artilces:

CRM 3.0 Implementation
I am interested in the experiences of others with implementing Microsoft CRM 3.0. I am a one man development team who has been tasked with implementing CRM 3.0 with 30 users initially. Our organization has been running on Lotus Notes for quite a while. We moved to echange for e-mail over a year ago but still use Lotus for custom databases. The first step will be pulling the data from Lotus Notes to CRM. I have looked into the Microsoft CRM 3.0 Certification. There is a company that offers a 10 day CRM 3.0 boot camp. Is this a good idea, and at what point should I take it? We would lik...

Can you insert a picture into a specific cell?
Or do they only "float" on the page. Marc They float over the worksheet, but you can adjust the size so that it seems to fit a cell exactly. If you insert a picture, you can hold the alt-key down while you move/resize the picture. When it gets close to the edge of a cell, it'll snap-to that edge. Marc wrote: > > Or do they only "float" on the page. > > Marc -- Dave Peterson ...

Summing Alternate Rows
We have spreadsheets with many rows and need to sum alternate rows. Is there a way to do this without entering a formula using the number of each row? -- KarenQ ------------------------------------------------------------------------ KarenQ's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19608 View this thread: http://www.excelforum.com/showthread.php?threadid=395115 Try this: =SUMPRODUCT(--(MOD(ROW($A$1:$A$18),2)=1),$A$1:$A$18) That formula sums odd-row values in the range A1:A18. To sum even-row values the formula is: =SUMPRODUCT(--(MOD(ROW($A$1:$A$18...

crm 3.0 error 03-01-06
Hello, I'me getting this error while installing crm3.0 for SBS: "error writing to file microsoft.mshtml.dll verify that you have access to that directory" That file is in the C:\Program Files\Microsoft.NET\Primary Interop Assemblies directory. I (and 'everyone') has full access to that dir. What can I do about this?? kind regards, Thomas ...

Joining text with a formula in cell #4
just to complete the thread... I found the answer. You have to change the format of the cell to custom 0.00"*" this is the only way it will show only 2 decimal places Thanks for the hel -- Mustard Hea ----------------------------------------------------------------------- Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630 View this thread: http://www.excelforum.com/showthread.php?threadid=27700 ...

Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current email folder's view, but how do I do it for all of the email folders? I have loads of email addresses each with lots of folders. I don't want to have to do each one at a time. Surely there must be a default font setting (even if it's only in the registry)? Thanks in advance, Tim. I too would love an answer to this. Ian "Timie Milie" <tim_milstead@yahoo.co.uk> wrote in message news:45782ee8$0$27107$db0fefd9@news.zen.co.uk... >I know I can change the column, row and preview font ...

Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with Office 2003 Service Pack 3 so that I could open Word documents with the file ext docx. Subsequent to the Service Pack 3 installation, whenever I open a Publisher file (which I created), I get the following message: "Publisher has detected a problem in the file you are trying to open. If you are certain that this file came from a trusted source and does not contain harmful information, click OK." What is causing this and is there a way to stop this pop-up message? All publications? Error message when you...

Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time solution for this is to zoom in or out. This is problematic as 60% seems to be the zoom that works most of the time but at this zoom level the cell contents do not display. The time lost and the frustration that builds is killing my productivity and office attitude. Please give all of us a permanet fix. -- Thanks Mike ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" butt...

Fractions Number format
Is it possible to do a custom number format for cells such that fractions are displayed. I'm guessing not because there'd be a limit on what fractions you could display, but I would probably only be interested in showing a half as the little 1/2 (alt,0189 I think) rather than .5 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.478 / Virus Database: 275 - Release Date: 06/05/03 Lee There are a limited number of fractions that can be shown under Format>Cells>Fractions. Gord Dibben Excel MVP - XL97 SR2 & ...

CRM 3.0 Login Problems
Some specific users are constantly getting prompted for CRM login in Outlook. We are using desktop client (online) online. This happens randomly. We have CRM 3.0 with rollup update 2 and IE7. We have also applied this fix http://support.microsoft.com/default.aspx/kb/934243/en-us. Also added the crm site to local intranet zone. Please help. Thanks. set the authentication in IE check rollup update 2 -- Regards, Imran MS CRM Certified Professional http://microsoftcrm3.blogspot.com Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com "raj" wrote: >...

Showing 3:54PM instead of 3:54:03PM
How do you get rid of the seconds in the time area. I have changed the formatting in the time. I use the excel file as a data source. I include the time in the mail merge. It always shows up with the seconds in the time. Very frustrating. HELP PLEASE!! TJ it may be formatted as text, so won't respond to changing the time format. if it is text, the TIMEVALUE formula will convert it to a decimal-based time value which can then be formatted by using Excel's normal Number formatting-- to get rid of the seconds. Eddie O "TJ" wrote: > How do you get rid of the secon...

Hyperlink problem #3
I've got two workbooks on a shared drive with hyperlinks linking the two. When a user clicks on the hyperlink on the first workbook, it takes him to the second workbook. Fine. However, when the user clicks on the hyperlink in the second workbook to go back to the first, the error message says that that workbook is already open and it cannot open two files with the same name. Help is appreciated! I just tried a small test in xl2002 and it worked ok for me. I use Insert|Hyperlink to create the links. Are you sure that the hyperlinks point at the file you want--same folder and e...

Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell in one sheet to another. I have a spreadsheet called "rating" which contains a number of formula that calculates a final number. I also have a spreadsheet called "Final" that copies over the information from "Rating". In "Final", I'm trying to copy a number from "Rating" into a particular cell. I put in =Rating! G89, but it won't work. When I press enter, a window pops up "Update value:Rating". I press enter again and in the cell where I want the number ...

Outlook Client #3
Dear All, I have recently installed crm outlook client for one of my users and then also installed the 2 rollups for version 3.0 . Unfortunately outlook is still restarting even after the rollups. Kidnly advise the necessary solution that resolve the problem. Please clarify, outlook loads and then crash "restart"? Has Office applied with latest Office update? Frank Lee, Microsoft Dynamics CRM MVP http://microsoft-crm.spaces.live.com http://www.workopia.com/Links.htm "Faiz Amir" wrote: > Dear All, > I have recently installed crm outlook client for one of my ...

Rounding Numbers #3
I have a list of values as below: 476.14 361.99 345.69 463.08 515.29 403.44 330.68 347.64 375.36 I would like to create a formula that rounds the values to the nearest 0.05 eg. Round 476.14 to 476.15, 361.99 to 362.00, 375.36 to 375.35 etc… Is there anyway that I can do this? Thanks, Jane. JaneC wrote: > I have a list of values as below: > 476.14 > 361.99 > 345.69 > 463.08 > 515.29 > 403.44 > 330.68 > 347.64 > 375.36 > I would like to create a formula that rounds the values > to the nearest 0.05 eg. Round 476.14 to 476.15, > 361.99 to 362.00, 375.36...

How to unlock locked cells by MACRO?!
I have locked Sheet and I need to change particular cells. But when my macro wants to change it => ERROR :/ Is there any way to unprotect these particulary cells by macro and change them? - after that action, of course, I want to lock them again. Please help me, Pedro Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like: activesheet.unprotect password:="yourpassword" 'your code to change stuff activesheet.protect password:="yourpassword" Petr N�me�ek wrote: > > I have locked Sheet and I need to change particular cells. But when m...

How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the values of all changed cells to the original saved ones. Any help would be appreciated. Thanks Dawn Hi this would require quite some VBA code as you somehow have to store the original values for example on a separate hidden sheet -- Regards Frank Kabel Frankfurt, Germany "Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im Newsbeitrag news:3340601E-16EE-4296-8F50-B0BAC18EA387@microsoft.com... > I want to add a reset button to an excel spreadsheet that will restore the > values of all ...

Referencing cells across sheets
Hi, I've created a workbook with three sheets. The first three columns of sheet 2 and sheet 3 are referenced to the first three columns of sheet 1. What I'd like to do, is set the workbook up so that if I insert a row before, between or after referenced rows in sheet one, a row will also be inserted, and referenced, in the corresponding place on sheets 2 and 3. Does anyone know how to do this? Also, if no data is entered into a cell on sheet one, the value shown in the corresponding cells of sheets '2' and '3' is '0'. I need those cells to remain bla...

SetWindowsHookEx #3
Hi there. Could someone explane to me what is the purpose of dwThreadId, the last member of SetWindowsHookEx function? I've expected that this is a thread id with which hooks is associated. That means that hook is getting only messages produced by this particular thread. But it looks like I'm getting system wide messages anyway. so could somone make it clear for me? In fact I need to process a mesages of only one window. I know the thread id of that window. But! this thread is not in my process! And I don't want a real system wide hook because it slows down the box. Ok, I think ...

RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from 1.2 to 1.3. My assessment will take in account the benefits, broken down by store operations (Retail) and the benefits to IT. Also, list risks and potential problems that might be experienced. We currently have 28 stores with 3+ registers per location with another 22 new stores on the schedule over the next 2 years. Are their other in this group of similiar size that have done this upgrade to the new version? 2.) If we do not upgrade the software, can we still integrate the RMS to Great Plains? Would we...

Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains formula, but it didn't work. "If cell value is equal to 0 then font - white" This doesn't work, stays always. If i use this condition on a cell without formula it works just fine. Thank -- si ----------------------------------------------------------------------- sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262 View this thread: http://www.excelforum.com/showthread.php?threadid=26784 Hi are you sure your formula returns an exact zero?. Could you post the formul...

How to save Japanese characters in CSV format of Excel ?
Hi, I would like to know, how to save the Doubly-Byte characters.For example, Japanese in CSV of Excel.Here are the steps, I tried. 1. Open Excel 2. Copy pasted the Japanese charactesrs in a cell.It is displaying the characters correctly. 3. Save as CSV(Comma seperated file) It is saving as ??????. Thanks in advance for the info. ...

Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3 When I use some formatting functions for the first time in a session, such as bold, increasing font size etc, it takes up to 30 seconds to work. Meantime Excel is locked up until it completes that formatting call. I suspect faulty DLL? Has anyone experienced this? How to fix (other than a complete re- install) ? Any advice appreciated. Piri On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote: > Excel 2000 SP3 > When I use some formatting functions for the first time in a > session, such as bold, increasing font size etc, it takes =A0up to 30 > secon...

Cell with large amount of data not showing all data
I'm running Excel 97. I have a cell with 358 words (1928 characters with spaces). Word wrap is on for the cell. Only part of the text is displayed even though the cell is big enough to show everything. If I make the cell wider (wider than a page) more of the text shows but not everything. I tried a new worksheet with the same text and had the same problem. Is this a known issue with excel? Is there a solution? Thanks, Brad Left to its own devices, excel will only show about 1000 characters in a cell. But you can add some alt-enters (to force a new line within the cell) and see more s...

Date format 04-11-06
Hi, Is there a possibility that the dates used in all the entities are not in the default format mm/dd/yyyy but in dd/mm/yyyy. I already adapted the Organisatonal settings, that only adapts the journal but nog the dates of an appointment. Does anyone have an idea? Thanks, ...