Select the range that starts with B5 and goes down as far as you want before opening the Conditional Formatting dialog. Select: New Rule. Select: Use a formula to determine which cells to format Enter your formula into the box labeled, "Format values where this formula is true" Click on the Format button and select the formats you wish. Confirm.
My Excel sheet had 102,300 rows and one column with date was messy. No amount of tricks were working. spent a whole day entering crazy formulas online to no success. See the snips How the column looked ("Short Date" format on Excel) The red circled cell contents (problematic ones) do not change at all regardless of what tricks you do.
Cell A1 contains a date. I am trying to turn cell A1 either red if this date is within 3 months or closer to today's date, yellow if between 3 and 6 months and if further away than 6 months, green....
A few more details. In the Excel document, the dates show as DD/MM/YYYY when formatted as Short Date. If I change the format of the column to General the flow runs correctly and the dates show in the emails as YYYY-MM-DD format, but they are displayed in the Excel document as integers whereas I want them to display as dates.
I'm looking for a way to automatically format the date in a VBA text box to a MM/DD/YYYY format, and I want it to format as the user is typing it in. For instance, once the user types in the second
Here is what I did. Before copying the data, select the column in Excel and select 'Format cells' and choose 'Text' and click 'Ok' (So, if your SQL data has the 3rd column as DateTime, then apply this formatting to the 3rd column in excel) Now, copy and paste the data from SQL to Excel and it would have the datetime value in the correct format.
15 I have made my own Gantt chart in Excel, which is shown in this picture: . I would like to highlight the whole column (or until the last activity) depending on the date, as shown in the picture. I figured out how to highlight a single cell depending on the date, but not a whole column.
2 Ok, Excel does some wacky stuff that it thinks is helpful when you're trying to apply conditional formatting to a range (it's usually more of a hindrance than help). Follow these steps: Select the first cell with a date value in it, I'm assuming E2. Click on Conditional Formatting -> New Rule. Select "Use a formula to determine which cells to ...
If you want Excel to treat the column as a date column, it should really have a date format, otherwise weird things will happen, which you've already experienced. However, you can refer to my latest edit for another possible workaround.
I'm trying to bring together string values using the CONCATENATE function in Excel. When I try include a date (source formatting is dd/mm/yyyy) it converts to Number type data and I've no idea how to get around this.
