Look at this link on conditional formatting and dates
https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/
Type: Posts; User: alansidman
Look at this link on conditional formatting and dates
https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/
Try this aircode:
Option Explicit
Sub ams()
Dim i As Long, lr As Long
lr = Range("A" & Rows.Count).End(xlUp).Row
Application.ScreenUpdating = False
In CE11 type =LEN(BW11)+LEN(BY11)+LEN(CA11)+LEN(CC11) and copy down
Suggest you upload a sample workbook with the expected results manually shown.
How about this:
Sub LastSaved()
Range("A1") = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Sub
Change the range appropriately
On the Excel Ribbon, Click on the Data Tab. Select Data Validation. Select Data Validation again.
In the allow box, select text length
In the data box, select less than
In the maximum box,...
crossposted: droplist
1. Created a new Sheet3
2. In cells A1:A4 entered list of four schools
3. In Name Manager, defined list with Name "List"
4. In Data Validation, changed look up to the defined "List"
See...
For starters, you have merged cells. VBA does not like and will not usually work with merged cells. You will need to redesign your workbook so that there are no merged cells. Additionally, in your...
In the reply window, click on the Go Advanced button. Look for the manage attachments button and follow the wizard to attach your workbook onto this forum.
With one table, it sounds like you may need to normalize your date into several tables.
Look at this link to understand what needs to happen. Once you have normalized data, it will be easier to...
It may be possible by joining the two queries into a new query that becomes the record source for your report. Without more detailed information from you that is the best i can do. Is the...
crosspost: Display date as MM/DD in reports
Look at this link: http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326
Your jpg is unreadable. Too small to read. Suggest you upload as an excel file.
Suggest you explain your issue in more detail. Not enough information to offer a solution.
Difficult to analyze the issue without seeing your spreadsheet. Tough to visualize what you have. Suggest you upload your spreadsheet with a detailed explanation of what you are attempting and what...
Images are pretty much useless to help solve issues. Upload sample worksheets with enough data to allow analysis and determine a suitable solution.
this will probably require some VBA. Suggest you post a sample worksheet so that members can provide you with specific code to meet your needs.
Try this:
Option Explicit
Sub NewDelete()
Dim W1Startdate As Date
W1Startdate = InputBox("Please Enter the Start Data in DD/MM/YYYY format")
Dim lr As Long
lr = Range("G"...
Try this:
Sub MYFILTER()
Dim W1Startdate As Date
W1Startdate = InputBox("Please Enter the Start Data in DD/MM/YYYY format")
range("A2:T" & range("A1").End(xlDown).Row).AutoFilter Field:=7,...
In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
Howard;
Please read this link:
http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326
Tested. Worked without issue. Had to change the sheet name to reflect my sheet name, but other than that, I used the code provided without any problems. If you would like further help, suggest you...
try this:
Option Explicit
Sub bold()
Dim lr As Long
lr = Range("A" & Rows.Count).End(xlUp).Row
Dim c As Range
Dim rng As Range
I have no experience with Java, and I suspect that the issue is with Java as you have the dates formatted correctly in Excel. I did a quick google search and found this link which may be helpful
...