i wanted to know if there is a way which i can so that would tell excel if a certain cell value is lower then another it would give a msg
for example
Cell A1 - 5
so if cell A2 is less then five and a macro is clicked then the macro would give a warning msg hence ending the macro
create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result
View 6 Replies View RelatedI M trying to get the lower values between to cells and have the lower valued cell highlighted,,,i have over 43 thousand lines of data to go throughand i was wondering if there was a quicker way to do this,,,for example cellA1 is $4.25 and cellA2 is $5.25 i want cell A1 to be highlighted,,is there a way?
View 2 Replies View RelatedI am trying to get a simple formula to look in A1 and if it is lower than A2 then return the value in A1 if it is not then return the value in A2..
View 4 Replies View RelatedI want to have some cells with conditional formatting.
The case here is date.
I have a given range of cells which will take on date. I will select all of these and will creat conditional formatting so that if the date is less than 2 days or more, have font colour change to red.
Now, the current date will be refered on a single cell.
I have done =($C$3-2) and it works but this does not account for anything older than 2 days.
What am I missing here? How do I do or less then?
I have a range of cells and I would like a warning message to pop up if a value over 0.1 is entered. I'm sure it is pretty easy to do, just can't find any info on here and I'm not great with Excel.
View 2 Replies View RelatedI have a spreadsheet that I am using to track competitor retail pricing
The problem is that I have a list of values and I want to be able to show how many of these values are either higher, lower or the same to a specific cell value. However one complexity that I have is that some of the competitors do not have values for all records (i.e. some are blank) and I want to discount these from the counting.
I've got a column of data that I need to split into further columns, the only way of identifying the split from the data is if a lower case character appears next to an upper case character.
For example, a cell in column A could look like;
Computer ProductsDrivesDVDExternal
And I'd need to split that out to cover columns A B and C with
Computer Products / Drives / DVDExternal
I'd need to do that for all the cells in column A.
I know the code is long, and bad, but I'm including it anyway in the hopes that it will give some clue. The activeworkbook.refreshall refers to a bunch of queries on other tabs of the workbook using VisualFoxPro ODBC if that matters...
View 9 Replies View RelatedI am trying to create an Excel spread sheet that keeps track of employees safety tickets and the dates they expire. Is there way to have a cell highlight to a color warning me 30 days prior to the due date listed?
I tried a conditional formatting as suggested in
[url] but that does not work.
I am using Microsoft Office Excel 2003 (MS Office Standard)(SP3)
if cell = null, then skip it to the lower cell.
the data is like this:
A361
A37
A38
A391
and i want to be like this:
A36
A39
without delete the row.
I need a formula that will give a warning if the date entered in cell is a weekend day.
View 2 Replies View RelatedWhen I try to copy formulas across do I get a little black plus-sign in the lower right corner of the cell, when I point to it. I can then drag the plus-sign to the the area where I want to copy the formula. This plus-sign has now disappeared.
View 3 Replies View RelatedI have a table that I use to generate about 20 graphs. The lower and upper limits can be manually altered in the table. If the user leave those 2 cells empty, I want the upper and lower limits be determined by default by Excel. So that the limits don't have to be entered for every graph in order for the graphs to be generated without any debugging error.
With ActiveChart.Axes(xlValue)
.MinimumScale = y1Lower
.MaximumScale = y1Upper
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
where
y1Lower = .Cells(i, j + 9)
y1Upper = .Cells(i, j + 10)
I want to have a warning message appear when a particular cell function result is a specific number, probably very simple to achieve.
View 9 Replies View RelatedThis is a logic based macro that needs to compare values in 1 column above a specific cell and take action until the column has no more data. Here's what I'm trying to do (and I've also attached a sample of desired results):
1) I want user to input starting cell. So I need to create a button for that.
2) This is where the logic begins and I'm having difficulty.
From cell defined in button, I move up one cell in that column and compare that value to the original cell.
If the value is greater than original cell then logic needs 2 outcomes:
a) move up 1 cell in column and if that value is less than original cell, then extract that value and copy that value one cell to the right or 1c.
b) move up 1 cell in column and if that value is greater than original cell, then move up again, until find lesser value than original cell. Once we find value less than original cell, extract value and copy value one cell to the right or 1c.
I am trying to find a macro that can search a sheet for any cell that contains the text "Not on AOI" selects a range that contains that cell, 81 rows below, and 2000 columns to the right, then cuts the selection and pastes it 162 rows below the original cell where the text was found. What's hard is that the number of columns between the "Not on AOI" cells is variable.
I'm very new to excel macros and the parts I think I've put together are:
Cells.Find("Not on AOI", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=True).Activate
[Code].....
Is there a data validation that will not allow all upper case or all lower case characters?
For examples:
Allow:
John Doe
101A N Woodbine Street
Disallow:
JOHN DOE
101A N WOODBINE STREET
Disallow:
john doe
101a n woodbine street
Or perhaps formatting that would convert the words to upper/lower case?
Or, I would be interested in VBA if it is the only way.
I have 83,33 value. If I like to increase into 84 and not 83 without decimal point
View 11 Replies View RelatedI have this code (this is just a snippet)
For Each cel In Range("E6:AI15").Cells
If IsError(cel.Value) Then
Else
Select Case UCase(cel.Value)
Case "H"
cel.Font.ColorIndex = 0
cel.Interior.ColorIndex = 3
Case "S"
cel.Font.ColorIndex = 0
cel.Interior.ColorIndex = 10
but I want the cells to accept both upper and lower case values and format the cells accordingly ie. H or h, S or s
I have looked in conditional formatting, but do not see a way to change lower case to all caps. Is there a way to do this so that when someone types in a cell it returns all caps instead of leaving it in lower case?
View 9 Replies View RelatedI have a lot of links on my excel page, links going to videos. Everytime I click the link, I have this message :
"there might be viruses... are you sure you want to open this file?"
I know there must be a way to take this message off : I worked with it for months, and then it suddenly disappeared. But now that I formatted, it's back again
I have several material takeoff sheets and one material SummarySheet in my workbook.
Each material takeoff sheet has a subtotal cell at the bottom of the sheet. The subtotals are added together and the total sum is displayed in a cell on the SummarySheet. At least that is how it is supposed to work. Excel or somebody else arbitrarily changed the cell reference in the SummarySheet formula to call up the cell one row above the subtotal cell on the material takeoff sheets. This little action resulted in a loss of $674,000 and may eventually result in my unemployment. Meanwhile I am sitting here putting out fires.
This is what I would like to do: Place a formula on the SummarySheet or add a Macro that will trigger a warning message box if the total on the SummarySheet is not equal to the sum of the subtotals on the material takeoff sheets. Also would like to have the message box animated or brightly colored.
If(PlateCostsTotals+AppurtenancesCostsTotals+StructuralCostsTotals+MiscellaneousCostsTotalsSummaryCostsTotal MsgBox “Hey, Don’t You Know How to Add”) or an alternate formula that works.
I recently added some code to close a file after a few minutes of inactivity. (Here's the sub code)
Sub time_out()
If Timer - LastEventTime
I am trying to put together a code so that when a user enteres more then two decimal points in the cell value they should get a warning regardless if they formatted the cell to show 2 decimals or not...
Simply the problem is on the sheet I have a lot of people format the cell to show two decimals but when you copy and paste the cell values to other sheets the decimals are still there which causes problems.
I am intermediete in VBA so if someone can shoot me some example codes I think I can make it work on my sheet.
I have a plan to create an excel sheet DB of softwares I sold to clients. Each license lasts 1 year. Here's an example of my sheet: ...
View 9 Replies View RelatedOn one laptop Excel crashes, without warning. It happens during copy/paste job (from one workbook to another). But not every time she copies something.
It is completly the same laptop like others in my company. My user has deadlines, and lot of copy/paste job.
I have an excel sheet there i am maintaining the details of our sales invoices. Invoice no is in the column D . My concern is while entering a new number in the column D, excel should look at the entire column and give an error message if the no is already exixting in the column.
View 9 Replies View RelatedI have an Excel file that contains macros that I made. Sometimes when I open the file I do not get prompted to enable macros. I DO want to get prompted so I can enable the macros. Any idea why this happens? By the way, my macro security is greyed out so I cannot change it.
View 3 Replies View RelatedThe values in F4:F14 are changed depending on the value in F2. The rows in green have a fixed value. The row in yellow has a lower limit (170)and upper limit (195). I cannot get a formula in F14 to perform this function.
View 3 Replies View Related