Summary: Hi: I'm trying to highlight the larger of two data columns side by side on the same sheet. ie: a1 3 b1 4 a2 6 b2 5 I want the larger of the two highl...
Summary: I am creating a shared sign-in sheet that shows who is still waiting to be seen. I am using the following function: =IF(B2>"",IF(E2="","WAITING","") T...
Summary: I don't use 2007, so I'll assume that by "rule" you mean that you are using Conditional Formatting. In 2003 I selected Row 10 by clicking on the row n...
Summary: Use Conditional Formatting. In 2007 I think it's under Home...Styles. How you get there is different than in 2003, but the concept is the same. See he...
Summary: What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional...
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,t...
Summary: Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format t...
Summary: I have a question about write a simple format in Excel of Office 2000. I want adding every nine line number togather ( example = c5+c14+c23+c32 ... un...
Summary: Hello. I am fairly new to conditional formating in Excel and would appreciate some help with a basic request. I use Excel 2007, and I would like to ...
Summary: I guess I've been using Conditional Formatting in the wrong way all these years. Shame on me. I also found a way to use VlookUp to reference an entry ...
Summary: Hi, I'm having some trouble with conditional formatting in Excel (i'm using windows vista). I want Excel to highlight a cell if the value of that cell...
Summary: My example was for an assumed date in A1, so I only gave the instructions for that row. If you want to conditionally format more rows, select them and...
Summary: Dear All, I have a small query on excel and conditional formatting. Here goes: I have a column that has all dates in them displayed as 02.08.2008 or 1...
Summary: Last week while entering data into Excel, I noticed that it started making me enter the date in opposite (example, instead of entering 07 10 for July ...
Summary: My newly installed excel 2003 cannot display the changes to cell formatting, i.e.the color of the word and fill of the cell, but it can display normal...
Summary: Dear friends If you would help me, it will a greatful that i am working in excel 2003. In one formula i have to use twelve time 'if' condition to get ...
Summary: Ok so I have a spread sheet in excel and I need 3 Conditional formatting. The first one is set Cell Value is less then A38 (i have the cell set up as ...
Summary: wheni am entering 6/30/2005 in my excel sheet it is appearing as 38533 (i guess numeric value of date) however in function bar it appears correct as 6...
Summary: Silly me. Nowhere in the code was copy or paste. :) I see the "=" in the For Next loop. I just don't know the syntax to VB well at all. I can sort...
Summary: Should be a pretty simple question for an Excel guru. I have two columns of text that are nearly identical except a few entries. I need a way to pul...
Summary: Highlight all the cells you want this applied to and then do your Condidtional Formatting for the first cell in the range. Excel will apply the Condit...
Summary: I could be wrong, but when Mike suggested "you'll have to divulge more information if you want us to help" I believe he meant some specifics as to wha...
Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you wan...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
